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
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.
The Item Type tells our system if the line is a product or
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.
An optional product code or stock keeping unit (SKU) which
is a specific number/bar code used to identify a product.
Apple Mighty Mouse
Product name is the unique identifier for the table. This
is a required field.
Here is where you can give a text description of your
Here you can specify the main category of each product.
The subcategory which lies under the main category, that
each product lives within.
A brand is the identity of a specific product, typically
The amount it will cost the customer to buy the product
Here you can set stock status of the product. Stock status
can be 'In Stock', 'Out of Stock' or 'On Order Only'.
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
This field represents list or market price. If higher than
product price, discount is displayed with product with cutted list price.
How much this product cost you to buy. This does not
appear on the storefront/website and is used for internal reporting purposes
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.
You can enter any warranty details for each product into
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.
One of the colors of your product.
Available sizes of your product or a color variant
Size List Name
The name of size list being used for this product. You may
have multiple size lists for different product types.
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
Y / N
Here you can set availability of color/size variant, if
any. (Y=yes N=no)
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.
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.
One of the other images of product.
You can specify URL of the product manufacturer's website.
Here you can specify unique meta keywords, or leave blank
to use default site wide keywords as defined in the Website Settings page.
Here you can specify a page/meta title, or leave blank to
use the product's name as the page title.
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.
Here you can tell if the product should be marked as 'New
Arrival' and visible on the storefront/website in the 'New Arrival' section.
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)
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:
Webx Ecommerce is the most popular ecommerce software in Pakistan. Powerful tools, industry integrations and an amazing customer support makes it the most trusted ecommerce solution in the region.
Office # 203, 2nd Floor, Business Center, Block-6, P.E.C.H.S., Shahrah-e-Faisal, Karachi
Phone: (92) 213 8892228
Mobile: (92) 333 3798885
Email: [email protected]
© Copyright 2023 Webx Ecommerce. All Rights Reserved.