Bulk Upload / Import/Export Tool : Jumix Support Portal

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

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.

Bulk Upload / Import/Export Tool Print