Importing & Exporting Bulk Products Data

You can bulk import your products in your website database using a CSV file format. Importing products is useful if you switched to Webx from another platform or if you want to make many changes to your products or inventory.

Get a sample .csv file

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.

Product CSV file format

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:

Item Type
Product ID
Product Code/SKU
Product Name
Description
Category
Sub Category
Brand
Price
Stock Status
Stock

If any of your product has size/color variants, then the following columns are also mandatory:

Color
Size
Size List Name
Option Active
Option Stock
Option Price

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	String (100)	Here you can specify the main category of each product.
SubCategory	Mouse	String (100)	The subcategory which lies under the main category, that each product lives within.
Brand	Apple	String (100)	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	String (Defined)	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	Number	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	Number	This field represents list or market price. If higher than product price, discount is displayed with product with cutted list price.
Cost	1200.00	Number	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	Number	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		String (100)	You can enter any warranty details for each product into this field.
Weight	0	Number	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	String (100)	One of the colors of your product.
Size	Small,Medium,Large	String (100)	Available sizes of your product or a color variant
Size List Name	Shirt Sizes	String (50)	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	Number	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	1, 2, 8	Number	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	sample.jpg	String (500)	One of the other images of product.
Image-3	sample.jpg	String (500)	One of the other images of product.
Image-4	sample.jpg	String (500)	One of the other images of product.
Web Link		String (500)	You can specify URL of the product manufacturer's website.
Meta Keywords		String (1000)	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		String (100)	Here you can specify a page/meta title, or leave blank to use the product's name as the page title.
Meta Description		String (1000)	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	Y / N	Character (Defined)	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	Y / N	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	Y / N	Character (Defined)	Here you can tell if the product should be visible on the storefront/website. (Y=yes N=no)

Import Product CSV

To import your product CSV, complete the following steps:

From your Webx admin, go to Products > Import Products.
In the Import Products by CSV, click Choose File.
Locate your CSV file, then click Open.
Click Import Products

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.

Export Product CSV

To export your stores existing product data on CSV:

From your Webx admin, go to Products > Export Products.
Click Export Products Data
Products data CSV file will be downloaded to your computer.