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 - Item | Description |
A - product_id | Unique product id for this product, not visible to public, must be unique and not overlap with any other product |
B- name | Name of the product |
C - categories | Input the categories_id of which this product belongs to |
D - SKU | Stock keeping unit, can be left blank |
E - upc | Universal product code, can be left blank |
F ~ J | Left blank |
K - quantity | Quantity of this products, inventory |
L - model | Model ID, visible to public and admin, must be unique and not overlap with any other product |
M - manufacturer | Input the manufacturer/brand name of which this product belongs to |
N - image_name | Input the directory of this product thumbnail picture, you can get the directory via FTP |
O - shipping | Put yes if required shipping. Put no if it's a downloadable/digital products |
P - price | Price of this product |
Q - points | Reward points of this product gives |
R and S | Leave it blank, system will auto generate upon import |
T - date_available | Adjust 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 - weight | Weight of this product |
V - weight unit | Weight unit, typically in kg |
W X Y | Dimension 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_keywords | The Meta keywords of this product. If you're on Deluxe/Ultimate Plan, skip this as it's automated |
AH - stock_status_id | Leave blank |
AI and AJ | Follow the previous product, typically 0 |
AK - related_ids | Input 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 - minimum | Minimum quantity that the customer must purchase. Typically 1 |
Additional Images Sheet
How do you get your image link?
In your Image Manger, right click your image and select Open image in new tab.
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.
Specials Sheet
Discount Sheet
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
ProductOptionValues Sheet
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.