Uploading Your Products in Bulk

Uploading your products in bulk or batch is the most convenient way of adding inventories to your store. But before doing a batch upload, download the templates available on the CMS (.zip file of CSV template and image folder) which you can download from the button next to the upload button. Clicking download will give you a zip file for that corresponding Bulk Upload type.

Product Types

• Simple Product
  A single product with no variations. Example: Bottled Water (500ml).
  
  
• Variable Product
  A product that comes in multiple variations such as size, flavor, or color. Example: Ice Cream (Flavors: Chocolate/Vanilla, Sizes: Pint/Tub).

Preparing Your .zip Files

To edit the .zip files:

1. Add all the Product images you want to use in the images folder.
   Make the filenames for the images easy to type in. This will be important later.
   
   
2. Edit the .csv file with the products you want to upload.

Editing the .CSV File

To edit the .csv file for Simple Bulk Upload:

1. Input the Name of the product (max. 50 characters)
2. Input the product Description (max. 300 characters)
3. Input the corresponding image name for the product and include the file extension (e.g. product.jpg, burger.png, etc).
4. Add the unique SKU code to be associated with the product
5. Enter the Stock Quantity to indicate the available inventory for the product
6. For Currency, enter “PHP”
7. Enter the Price of the product
8. Input a Variation Code -
   For simple products, this field is still required but should just be a unique identifier (e.g., VAR001). This helps the system uniquely identify the product.
9. Set Visibility to 1

Items 9 use a binary code. For this case, 0 means "yes" and 1 means "no".

To edit the .csv file for Variable Bulk Upload:

1. Input the Name of the product (max. 50 characters)
2. Input the product Description (max. 300 characters)
3. Input the corresponding image name for the product and include the file extension (e.g. product.jpg, burger.png, etc).
4. For Currency, enter “PHP”
5. Set On Sale to 0
6. Set Visibility to 0
   
   Items 5 and 6 use a binary code. For these cases, 0 means "yes" and 1 means "no".
7. Variation Attribute
   When creating product variations, follow this format:
   
   Format:
   
   Attribute: Choice 1 | Choice 2 + Attribute: Choice 1 | Choice 2
   
   

• Use “+” to separate different attributes
• Use “:” to separate the attribute name and its variations
• Use “|” to separate each variation

Example:

Flavor: Chocolate | Vanilla + Size: Pint | Tub

This will create 2 attributes with their variation choices:

• Flavor → Chocolate, Vanilla
• Size → Pint, Tub

1. Inventory
   For each variation created, you need to add SKU code, stock count, and price.
   
   Format
   
   Choice1_Choice2: SKU | Stock | Price + Choice1_Choice2: SKU | Stock | Price
   
   It doesn’t mean you repeat the same Choice1 and Choice2.
   It means you must list every possible combination of your attribute choices.

Example with Flavor + Size

Attributes you set :

• Flavor: Chocolate | Vanilla
• Size: Pint | Tub

Possible combinations (what the customer can pick):

1. Chocolate + Pint
2. Chocolate + Tub
3. Vanilla + Pint
4. Vanilla + Tub

How to write them in the required format:
Chocolate_Pint: CHPINT|10|100.00 + Chocolate_Tub: CHTUB|10|200.00 + Vanilla_Pint: VNPINT|15|90.00 + Vanilla_Tub: VNTUB|15|180.00

What these combination means (Flavor + Size)

1. Chocolate + Pint → 10 stocks at ₱100.00 each (SKU: CHPINT) 
2. Chocolate + Tub → 10 stocks at ₱200.00 each (SKU: CHTUB) 
3. Vanilla + Pint → 15 stocks at ₱90.00 each (SKU: VNPINT) 
4. Vanilla + Tub → 15 stocks at ₱180.00 each (SKU: VNTUB)

Sample files can be downloaded from this link. Look for the file you want to download then right click to download. Once the form is accomplished and images are added into the image folder, you can upload your product list.

To upload your list of simple products from the Products tab of your eStore module:

1. Click Upload Simple Product
2. Select the appropriate .zip folder which should contain:
   1. The accomplished Simple Product .CSV file
   2. The image folder with all product images
3. Confirm upload.

To upload your list of variable products from the Products tab of your eStore module:

1. Click Upload Variable Product
2. Select the appropriate .zip folder which should contain:
   1. The accomplished Simple Product .CSV file
   2. The image folder with all product images
3. Confirm upload.