ChatGenie’s latest feature now allows merchants like you to add products in bulk by simply uploading a CSV file! This comes especially handy for businesses with big product lists that have to be uploaded one by one. Let’s get right to it!
How do I do it?
Start in the ChatGenie Dashboard and go to the Categories & Products Menu and select Products from the dropdown.
From there, select the Batch Upload button at the top right part of your screen. You’ll find it beside the export button.
A Pop-Up window will then be displayed to let you start the process:
First, you can download a sample CSV template to see an example of the format required. If you already have an existing product catalog, you can edit the CSV file instead to follow the headers and format below.
the CSV file will show you the required headers:
published - This is to determine if the product will be published in your Mini App online store. This header is where you can decide whether or not you want to show a specific product. If you leave it blank, all products will still be published by default. To select which products will be shown, add in the following values: TRUE (to publish your product) or FALSE (to hide your product in the Mini App but save it on your dashboard.)
productType * - This is where you define your type of product. Choose from physical or digital. Physical products include most retail items you can think of while digital products refer to products you only buy online and don’t need a delivery address.
productName * - In this section, you need to add in all your product names. This can be as simple as “White T-Shirt” or as detailed as “White Cotton T-Shirt with Graphic Print”.
productDescription * - Describe your products here. Try to use concise yet descriptive copy to help customers get a picture of what your product is without having to see it in person.
productCategories * - Lastly, input the category of each product here. Just separate each category with a comma. If the product category is exactly the same as any of the existing categories, the product will be displayed under that category. If you want to create a new category, simply add one here and it will be automatically created.
basePrice * - This is the base price of the product. You can add to the base price by specifying it in the Variant Price mentioned below.
You can also add in the dimensions of your products here so your customers know exactly what to expect. This portion (and the next two) also helps in case you want to deliver your orders via Lalamove. Knowing these details will help you configure which vehicle to choose for your delivery:
length (in.)
width (in.)
height (in.)
optionName - Use this portion to add specific product attributes like size and color.
optionValues - These are values referring to a specific product attribute. You can add more than one simply separate each with a comma.
optionValueId - This refers to your product’s variant names. Input the value and separate them with commas but no space. For example, you can input "small,medium,large".
optionValueStockQuantities - Add in the value of your available inventory here. If left blank, stock quantity will automatically register as unlimited. If you have product variants, you will also be asked to input the stock quantity for each product.
optionValuePublishes - Put "TRUE" if you want this product to be visible and "FALSE" if not.
variantTypes - Type "physical" if this is a physical product and "digital" if not.
variantPrices - As mentioned, you can also add supplemental fees or prices on top of the base price to some product variants here. You can add several variant price values, just separate them by a comma.
*required
Now that you’ve added all the information needed for your batch upload, click the Add File button, upload, and continue to finalize your upload. Once that’s done, all you’ll have to do is upload your photos (don’t worry, we’re working on a Batch Upload feature for photos too)!
Download a Batch Upload file template HERE.