<p>With the bulk product upload feature, you can upload your products in bulk with the help of a CSV file.<br><br>Bulk upload has options to add new products and edit existing products:<br><br><strong>Add Products: </strong>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.<br><br><strong>Edit Products: </strong> 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. <br>For example, if you want to update the stock and prices of your products, your CSV template should be like this:<br><span style="color: rgb(35, 111, 161);">"id","price","price_discounted","stock"</span><br><br>Example:<br><span style="color: rgb(35, 111, 161);">"id","price","price_discounted","stock"</span><br><span style="color: rgb(132, 63, 161);">"1","30","20","1000"</span><br><span style="color: rgb(132, 63, 161);">"5","40","40","500"</span><br><br><span style="color: rgb(186, 55, 42);">* To update the product price, you need to add both "price" and "price_discounted" columns to your CSV file.<br><br><br></span></p>
<p><span style="font-size: 12pt;"><strong>CSV Columns</strong></span></p>
<table style="width: 100%;" class="table table-bordered">
<tbody>
<tr>
<th>Column</th>
<th>Description</th>
</tr>
<tr>
<td style="width: 180px;">title</td>
<td>Data Type: Text <br><strong>Required</strong><br>Example: Modern grey couch and pillows</td>
</tr>
<tr>
<td style="width: 180px;">slug</td>
<td>Data Type: Text <br><strong>Optional</strong> <small>(If you leave it empty, it will be generated automatically.)</small> <br>Example: modern-grey-couch-and-pillows</td>
</tr>
<tr>
<td style="width: 180px;">sku</td>
<td>Data Type: Text <br><strong>Optional</strong><br>Example: MD-GR-6898</td>
</tr>
<tr>
<td style="width: 180px;">category_id</td>
<td>Data Type: Number <br><strong>Required</strong><br>Example: 1</td>
</tr>
<tr>
<td style="width: 180px;">price</td>
<td>Data Type: Decimal/Number <br><strong>Required</strong><br>Example 1: 50<br>Example 2: 45.90<br>Example 3: 3456.25</td>
</tr>
<tr>
<td style="width: 180px;">price_discounted</td>
<td>Data Type: Decimal/Number <br><strong>Optional</strong><br>Example 1: 40<br>Example 2: 35.90<br>Example 3: 2456.25</td>
</tr>
<tr>
<td style="width: 180px;">vat_rate</td>
<td>Data Type: Number <br><strong>Optional</strong><br>Example: 8</td>
</tr>
<tr>
<td style="width: 180px;">stock</td>
<td>Data Type: Number <br><strong>Required</strong><br>Example: 100</td>
</tr>
<tr>
<td style="width: 180px;">short_description</td>
<td>Data Type: Text <br><strong>Optional</strong><br>Example: It is a nice and comfortable couch</td>
</tr>
<tr>
<td style="width: 180px;">description</td>
<td>Data Type: Text <br><strong>Optional</strong><br>Example: It is a nice and comfortable couch...</td>
</tr>
<tr>
<td style="width: 180px;">tags</td>
<td>Data Type: Text <br><strong>Optional</strong><br>Example: nice, comfortable, couch</td>
</tr>
<tr>
<td style="width: 180px;">image_url</td>
<td>Data Type: Text <br><strong>Optional</strong><br>Example 1:<br>https://upload.wikimedia.org/wikipedia/commons/7/70/Labrador-sea-paamiut.jpg<br><br>Example 2:<br>https://upload.wikimedia.org/wikipedia/commons/7/70/Labrador-sea-paamiut.jpg,<br>https://upload.wikimedia.org/wikipedia/commons/thumb/4/42/Shaqi_jrvej.jpg/1600px-Shaqi_jrvej.jpg<br><br><span style="color: rgb(186, 55, 42);">*You can add multiple image links by placing commas between them.</span></td>
</tr>
<tr>
<td style="width: 180px;">external_link</td>
<td>Data Type: Text <br><strong>Optional</strong><br>Example: https://domain.com/product_url</td>
</tr>
<tr>
<td style="width: 180px;">updated_at</td>
<td>Data Type: Timestamp <br><strong>Optional</strong><br>Example: 2024-06-30 10:27:00 <br><br><span style="color: rgb(186, 55, 42);">*If you leave it blank, the system will not assign an update date.</span></td>
</tr>
<tr>
<td style="width: 180px;">created_at</td>
<td>Data Type: Timestamp <br><strong>Optional</strong><br>Example: 2024-06-30 10:27:00 <br><br><span style="color: rgb(186, 55, 42);">*If you leave it blank, the system will automatically assign the current date.</span></td>
</tr>
</tbody>
</table>
<p><br><br><br><br><br></p>