To access bulk upload or import/export tool, navigate to System > Maintenance > Export / Import *if this doesn't appear in your admin panel, kindly contact our support team*



Before you get started, it's recommended that you first upload all your product images to the store first, and properly organized them into different folders.


Start by selecting the data you want to export. We'll only be talking about Products here. So select Products and click on Export button.

Depending on how large your files and database is, this process may take a few minutes to load before the download will appear, be patience and do not navigate away from this page. However, you can open links in new browser tab.

The more categories/products you have, the larger your database is.


Once the download is complete, you should open up the file with Microsoft Excel.


Product Sheet

On the first sheet you should see the Product data, now we'll go through each of the column.


Column - ItemDescription
A - product_idUnique product id for this product, not visible to public, must be unique and not overlap with any other product
B- nameName of the product
C - categoriesInput the categories_id of which this product belongs to
D - SKUStock keeping unit, can be left blank
E - upcUniversal product code, can be left blank
F ~ JLeft blank
K - quantityQuantity of this products, inventory
L - modelModel ID, visible to public and admin, must be unique and not overlap with any other product
M - manufacturerInput the manufacturer/brand name of which this product belongs to
N - image_nameInput the directory of this product thumbnail picture, you can get the directory via FTP
O - shippingPut yes if required shipping. Put no if it's a downloadable/digital products
P - pricePrice of this product
Q - pointsReward points of this product gives
R and SLeave it blank, system will auto generate upon import
T - date_availableAdjust the date if you don't want the product to be public instantly. If you want it to available upon import, leave it blank
U - weightWeight of this product
V - weight unit Weight unit, typically in kg
W X YDimension of length, width and height if applicable, can be left blank
Z - length_unit Length unit, usually in cm
AA - status Put true for Enabled, false or Disabled product 
AB - tax_class_id If you enabled tax system, you can assign the tax id with the product here 
AC - seo_keyword The SEO keyword or SEO URL for this product. If you're on Deluxe/Ultimate Plan, skip this as it's automated 
AD - description The description of your product. The format should be in HTML formatting.  
AE - meta_title The Meta title of this product. If you're on Deluxe/Ultimate Plan, skip this as it's automated
AF - meta_description The Meta description of this product. If you're on Deluxe/Ultimate Plan, skip this as it's automated 
AG - meta_keywordsThe Meta keywords of this product. If you're on Deluxe/Ultimate Plan, skip this as it's automated 
AH - stock_status_idLeave blank 
AI and AJ Follow the previous product, typically 0 
AK - related_idsInput the related products ID if you want, can be left blank 
AL - tags Tags for this products 
AM - sort_order Leave blank
AN - subtract If you want thsi product to substract stock, put true. If not, put false
AO - minimumMinimum quantity that the customer must purchase. Typically 1


Additional Images Sheet

On the second sheet of the excel, you will find the Additional Images data.
This is just a simple 3 columns data for you to fill in the additional images for each products.
If you only have 1 image for 1 product, you can skip this sheet all over.

First you'll need to upload your products in the store via admin panel, and then you can link them in this excel sheet.
On column A, input the product_id in column A, you can find the product_id in the first Sheet in the same excel file.
Then on column B - image, input the directory for the image according to your image link.

How do you get your image link?

In your Image Manger, right click your image and select Open image in new tab.


You will see the link to this image in your browser address.

You only need to copy whatever that is behind your domain name and behind /image.

For example, if your domain is abcde.com, and the link is abcde.com/image/catalog/brands/picture.jpg, you just need to copy catalog/brands/picture.jpg.


Every pictures inside the same folder will have the same link, so you just need to change according to the file name, the path will be the same.

Eg.

catalog/brands/nike.jpg

catalog/brands/adidas.jpg

^ these are all images inside "brands" folder.


catalog/product/1.jpg

catalog/product/2.jpg

^ these are all images inside "product" folder.



Repeat for all other additional images you have on the product.



Specials Sheet

This is similar as setting Specials in your Admin panel.
Column A - input the product_id you want to have specials here (or promotion, for your easier understanding)
Column B - customer_group, input the customer group that you want this specials to, you can leave it to default if you have never set any special customer group 
Column C - Set the priority of this Specials if you have multiple Specials on the run
Column D - Set the Special price here
Column E - Set the starting date of this Special promotion
Column F - Set the ending date of this Special promotion


Discount Sheet

This is very similar with Specials sheet, so you can refer to the above and the only difference is with Column C, quantity.
Set the quantity in order to enjoy this discounted price.


Rewards Sheet

Column A - input the product_id you want to have set reward points

Column B - customer_group, input the customer group that you want this reward points to give to to, you can leave it to default if you have never set any special customer group 

Column C - input how many points you want to give for the product



ProductOptions Sheet

This is the master list of all your products. It is highly recommended that you don't change anything here and just change the value in your admin panel.


ProductOptionValues Sheet

You can add the option values to each Master option in this sheet.
This sheet should already have some sample data for you to refer on.
Take note that you should always create the Master Option first (in either Admin Panel or ProductOptions sheet) before you proceed to add the option values here.

Column A - input the product_id you want to insert the option values

Column B - the option name of the Master Option, must be already created

Column C - the option values, or choices

Column D - the quantity for this particular option values

Column E - Whether this option should substract stock, true for yes, false for no

Column F - This column is in use only if your different options values have different prizes. If let say all your option values are having the same price, just put 0.00. If you are selling T-shirt that have S,M,L sizes and M size is more expensive by $5, then put 5.00 here. Pay attention in next column

Column G - Continued from Column F, if size M is more expensive by $5, then this column you should input "+". If it's cheaper, then you should put "-".

Column H - Reward points for purchasing this particular option item

Column I - Same concept as Column F and G, just in the matter of reward points instead of price

Column J - Weight of this option value, if all weight the same, just put 0

Column J - Same concept as Column G and I, just in the matter of weight instead of price/reward points.