Call Us: 021 34322477, 0333 3798885|[email protected]
/ / Import & Export Products Data

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:

  1. From your Webx admin, go to Products > Import Products.
  2. In the Import Products by CSV, click Choose File.
  3. Locate your CSV file, then click Open.
  4. 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:

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

Start your free 14-day trial today!

Get Started!