Simplify the process of adding products to your ecommerce website by bulk importing them using a CSV file format. Whether you're switching to Shappio from another platform or need to make multiple changes to your product inventory, importing products can save you time and effort.
You can download and view a sample product CSV file to use as a template for creating your own CSV files.
The sample contains an example product and a couple of variants. Your import file will likely contain many more products and variants. If you use the sample file to create your own import file, then make sure that you remove all the example products.
You can import products into your store from a CSV file, which you can easily create with a spreadsheet program like Microsoft Excel, OpenOffice Calc, or Numbers. The first line of your product CSV needs to include the field headers described in the table. Subsequent lines in the file should contain data for your product using the same fields in that exact same order as in field headers.
Following are the mandatory columns for any product import:
If any of your product has size/color variants, then the following columns are also mandatory:
While all the rest of the fields are not mandatory. For importing new products, you have to include other important data.
Product CSV Fields Following is a complete list and detail of all fields that can be imported through CSV file. Please note that the column names in your CSV file MUST be the same as mentioned below.
Field Name
Example
Type/Limit
Field Description
Item Type
Product/Variant
String (Defined)
The Item Type tells our system if the line is a product or a variant.
Product ID
12345
Number (Auto-Generated)
The Product ID is uniquely defined by the database and cannot be created manually. When importing NEW products please leave this field blank. If you are re-importing existing products then you have to use the already existing product ID provided from the bulk export.
Product Code/SKU
AD5001
String (50)
An optional product code or stock keeping unit (SKU) which is a specific number/bar code used to identify a product.
Product Name
Apple Mighty Mouse
String (100)
Product name is the unique identifier for the table. This is a required field.
Description
String (1000)
Here is where you can give a text description of your product.
Category
Computer Accessories
Here you can specify the main category of each product.
SubCategory
Mouse
The subcategory which lies under the main category, that each product lives within.
Brand
Apple
A brand is the identity of a specific product, typically the manufacturer.
Price
1499.99
Number
The amount it will cost the customer to buy the product from you.
Stock Status
In Stock
Here you can set stock status of the product. Stock status can be 'In Stock', 'Out of Stock' or 'On Order Only'.
Stock
1, 2, 8
This is the available product stock. This field is used when you track inventory of a product, and it overrides Stock Status field based on available stock. If you do not track product inventory, leave it blank.
List Price
1200.00
This field represents list or market price. If higher than product price, discount is displayed with product with cutted list price.
Cost
How much this product cost you to buy. This does not appear on the storefront/website and is used for internal reporting purposes only.
Shipping Price
100
Fixed shipping is the cost to ship one unit of this product. If left blank, the default shipping calculator will be used during checkout. Please remember that a fixed shipping cost will override any shipping method in your store when this product is purchased.
Warranty
You can enter any warranty details for each product into this field.
Weight
0
If you are using a physical product which needs to be fixed, then you must enter a weight for each product(in LBS) so that it can be used to calculate shipping costs when ordering.
Color
Black
One of the colors of your product.
Size
Small,Medium,Large
Available sizes of your product or a color variant
Size List Name
Shirt Sizes
The name of size list being used for this product. You may have multiple size lists for different product types.
Option Price
1200, +200, -150
Price for any color/size variant of a product. If left blank, the actual product price is applied. Price difference with respect to actual price can be applied by adding + or - sign before the difference amount.
Option Active
Y / N
Character (Defined)
Here you can set availability of color/size variant, if any. (Y=yes N=no)
Option Stock
This is the available product option stock. This field is used when you track inventory of a product options, and it overrides Option Status field based on available stock. If you do not track product option inventory, leave it blank.
Image-1
sample.jpg
String (500)
This is the main image of product. This field contains URL of the product image where it automatically gets downloaded from. If you have exported pre-existing products then this field contains the file name of the image already available on your website, and you can disregard this field, unless you need to change the image.
Image-2
One of the other images of product.
Image-3
Image-4
Web Link
You can specify URL of the product manufacturer's website.
Meta Keywords
Here you can specify unique meta keywords, or leave blank to use default site wide keywords as defined in the Website Settings page.
Meta Title
Here you can specify a page/meta title, or leave blank to use the product's name as the page title.
Meta Description
Here you can specify a unique meta description, or leave blank to use product description or default site wide description as defined in the Website Settings page.
New Arrival
Here you can tell if the product should be marked as 'New Arrival' and visible on the storefront/website in the 'New Arrival' section. (Y=yes N=no)
Featured
Charater (Defined)
Here you can tell if the product should be marked as 'Featured' and visible on the storefront/website in the 'Featured Products' section. (Y=yes N=no)
Active
Here you can tell if the product should be visible on the storefront/website. (Y=yes N=no)
To import your product CSV, complete the following steps:
When your CSV file is successfully uploaded you will see a summary of import, with number of products, categories and brands that were added or updated.
To export your stores existing product data on CSV: