Import System is the fastest way to add/edit your products as a bulk. If you have already added products on another ecommerce platform or you want to make changes on your products, Import System will be your biggest assistant.
Instead of adding each product one by one, Shopio takes data from your CSV file and adds your all products just in minutes.
You can download our Sample CSV file via below link and edit it according to your product information. Don't forget to delete sample product data.
Important: If you wish to import a CSV file which is exported from another platform, be sure that the file format is same with Shopio's samle CSV file in order to be uploaded to your Shopio Store successfully.
The first line of your CSV file must have the field headers described below. You can change the order of the Fields (Ex. Sample CSV comes in an order like Handle, Title, SKU, etc. You can change this order like Title, SKU, Handle, etc.) but you can't change the Field Names, you can't add or delete Fields.
Editing csv file
As mentioned above, your CSV file must be formatted same as Shopio's sample CSV file. You can find Shopio's CSV file's field explanations below:
While editing your Import CSV file please pay attention to the cases listed here to run a successful importing process.
Handles are unique names for each product. They can contain letters, dashes and numbers, but no spaces.
Every line with different handle will be treated as a new product. If you wish to add products with variants you should use the same handle name with the main product.
Example for product with variants:
In the below image, as you see in the Handle field, between Line 2 and 10 has the same Handle Name which is mandatory to be able to add Product Variants with Import. Line 2 will be treated as main product (Option fields are empty) and the other lines with the same Handle name (3-10) will be treated as variants.
Process gives an error if you enter same variations into more than one field. Example if you enter "Red" for "Option Value 1" and "Small" for "Option Value 2" into both Line 3 and Line 4 system gives an error.
(Required) Your product title. Example: My Product
(Optional) The SKU of your product. SKU is for tracking your inventory much more easier. If left blank, system gives an automatic SKU for the product.
SKU has an important role if you are using Import System to update your existing product informations. Import file SKU must be same as existing product SKU to update that product. Otherwise system will add that as a new product.
(Optional) Your product's brand. Example: Unit Portables, Apple, Sony, etc.
Option Name 1
For products with Options. Enter the Option name. Example: Color
Option Value 1
(Required if Option Name 1 is entered) For products with Options. Enter the Option value. Example: Red
Option Name 2
If a product has a second option, enter its name. Example: Size
Option Value 2
(Required if Option Name 2 is entered) If a product has a second option, enter its value. Example: Small
Option Name 3
If a product has a third option, enter its name. Example: Material
Option Value 3
(Required if Option Name 3 is entered) If a product has a third option, enter the value of the option. Example: Cotton
(Optional) Your product's category name. If this is a new category (non existing on your store), the system will create it for you.
(Optional) Enter your product's Tax Group name if you have setted special tax groups on your store. If left blank comes as "Default".
(Optional) The weight of your product. If you are using wight based shipping rates, don't forget to fill this area.
(Required) Your product's price. If wou wish to use decimals please use " . " Don't use any currency symbols here. Example: 39.95
(Required) 1: Track, 0: Do not track.
(Required if Stock Tracking is 1. ) For the product's that you enter Stock Tracking as 1, enter your Stock Amount. Can be left blank if stock tracking is 0.
(Optional) Your product's description. Must be in HTML format. (between <p> </p> )
Example: <p> Your Text Here </p>
Example for Description field.
(Optional) Your Product Image. If the line is a variant line, will be treated as variant image. The URL must be working to import it successfully. Once you add it successfully, your store keeps it on its own storage. Must be .jpg, .jpeg, .png or .gif formatted and max 4 MB.
(Optional) Second image of your product. If this is a variant line, this will not be imported to your store just because Shopio allows to add only one image for each variant. If you enter a URL into Image 4 field of a variant line, your import process won't be terminated but image won't be added.
(Optional) Third image of your product. If this is a variant line, this will not be imported to your store just because Shopio allows to add only one image for each variant. If you enter a URL into Image 3 field of a variant line, your import process won't be terminated but image won't be added.
(Optional) Fourth image of your product. If this is a variant line, this will not be imported to your store just because Shopio allows to add only one image for each variant. If you enter a URL into Image 4 field of a variant line, your import process won't be terminated but image won't be added.
While adding products manually, you can add more than 4 images to your products but via import, you can add max 4 images.
(Optional) Meta Title of your Product. (For search engines.) If left blank, product title will be your Meta Title. Use max 60 characters (recommended).
(Optional) Meta Description of your Product. (For search engines.) Use max 160 characters (recommended).
(Optional) Meta Keywords of your Product. (For search engines.) Use commas to seperate a keyword from another. Example: red apple, blue apple, yellow apple
To Start Importing;
1- Go to Products >> All Products menu, click on the IMPORT button on the top left of the page.
2- A pop-up window will show up. On that window, select your CSV file and click on the UPLOAD FILE button.
3- Don't close the Import window until you see the Success message.