Bulk Product Upload
With the bulk product upload feature, you can upload your products in bulk with the help of a CSV file.
Bulk upload has options to add new products and edit existing products:
Add Products: To add new products, download the CSV template, add your products to this CSV file and upload it from this section. You can see detailed explanations of all required or optional columns in the table below. When adding your data, you need to pay attention to the data type of these columns.
Edit Products: To edit products, you need to add an "id" column to the CSV template. You can see the ID numbers of your products on the "products" page. After adding the "id" column, you need to add the column names you want to edit.
For example, if you want to update the stock and prices of your products, your CSV template should be like this:
"id","price","price_discounted","stock"
Example:
"id","price","price_discounted","stock"
"1","30","20","1000"
"5","40","40","500"
* To update the product price, you need to add both "price" and "price_discounted" columns to your CSV file.
CSV Columns
| Column | Description |
|---|---|
| title | Data Type: Text Required Example: Modern grey couch and pillows |
| slug | Data Type: Text Optional (If you leave it empty, it will be generated automatically.) Example: modern-grey-couch-and-pillows |
| sku | Data Type: Text Optional Example: MD-GR-6898 |
| category_id | Data Type: Number Required Example: 1 |
| price | Data Type: Decimal/Number Required Example: 50 Example: 45.90 Example: 3456.25 |
| price_discounted | Data Type: Decimal/Number Optional Example: 40 Example: 35.90 Example: 2456.25 |
| vat_rate | Data Type: Number Optional Example: 8 |
| stock | Data Type: Number Required Example: 100 |
| short_description | Data Type: Text Optional Example: It is a nice and comfortable couch |
| description | Data Type: Text Optional Example: It is a nice and comfortable couch... |
| tags | Data Type: Text Optional Example: nice, comfortable, couch |
| image_url | Data Type: Text Optional Example: https://upload.wikimedia.org/wikipedia/commons/7/70/Labrador-sea-paamiut.jpg Example: https://upload.wikimedia.org/wikipedia/commons/7/70/Labrador-sea-paamiut.jpg, https://upload.wikimedia.org/wikipedia/commons/thumb/4/42/Shaqi_jrvej.jpg/1600px-Shaqi_jrvej.jpg *You can add multiple image links by placing commas between them. |
| external_link | Data Type: Text Optional Example: https://domain.com/product_url |
| updated_at | Data Type: Timestamp Optional Example: 2024-06-30 10:27:00 *If you leave it blank, the system will not assign an update date. |
| created_at | Data Type: Timestamp Optional Example: 2024-06-30 10:27:00 *If you leave it blank, the system will automatically assign the current date. |