This article explains how to avoid errors when importing (uploading) and exporting (downloading) products in the Store.
Important! Before working with a local table, create a few products in your puzzlebot account and export the table, then work with the file you get.
Rules for working with the product table:
The table is exported in CSV format, with ";" as the column delimiter.
To open the table correctly in Microsoft Excel:
Create a new document.
Go to the Data tab.
Select From Text.
Select the downloaded table file in CSV format.
Select the Delimited data type.
Select Unicode UTF-8 as the File origin (encoding).
Click Next.
Select only the Semicolon checkbox.
Click Next.
Click Finish.
Add the table to the current sheet or a new one.
The table is imported in CSV format. When saving the table, don't forget to change the format to CSV.
The first column, ID, links a product in your puzzlebot account to the changes in the local table (the table exported from your puzzlebot account). Key points:
If the ID of a product or product group in your puzzlebot account does not match the ID in the local table, the changes are not applied.
If the ID of a product or product group is missing in the local table, a new product or product group is created.
Column descriptions:
id — the identifier of a product that already exists in the store.
name — the product name.
description — the product description.
count — the product stock. Values:
Empty — for a product group.
"-1" — unlimited quantity.
"0" — out of stock.
"1" or more — the quantity in stock.
Important! Use "-1" for a digital product; the actual quantity of a digital product depends on the promocodes field.
preview_link — a link to the file shown as the product preview (image, video, document and so on). File size: 100 KB at most.
send_preview_as_document — send the preview as a document. Values:
"0" — sends it as a regular message containing media (an image is sent as an image, a video as a video).
"1" — sends it as a document (photos, videos and everything else are sent as files).
article — the product SKU (a unique number).
Empty — for a product group.
enabled — whether the product is active. Values:
"0" — disabled.
"1" — enabled.
category — the product category name. Important! If the category name in your puzzlebot account does not match the category name in the local table, a new category is created.
purchase_success_command — the name of an existing command to go to when the product is paid for successfully.
Empty — for a product group.
promocodes — the list of unused items of a digital product. Important:
For a product group, leave the field empty.
For a regular product, leave the field empty.
For a digital product, add all items and separate them with ",". If a list item contains a comma, replace it with a double comma ",," so that on import the site understands it is a comma and not a separator.
promocodes_variable — the variable name for a digital product.
For a product group, leave the field empty.
For a regular product, leave the field empty.
For a digital product, enter the variable without the "{{}}" characters.
promocodes_multiple — whether the items of a digital product are reusable (cyclic use).
For a product group, leave the field empty.
For a regular product, leave the field empty.
For a digital product: "0" — cyclic use is off, "1" — cyclic use is on.
promocodes_random_order — use the items of a digital product in random order.
For a product group, leave the field empty.
For a regular product, leave the field empty.
For a digital product: "0" — random order is off, "1" — random order is on.
is_parent — whether the product is the parent of a product group. Values:
Empty — it is not.
"1" — it is.
group_id — the product group identifier. Important:
If products are combined into a group, the group must have one parent with the value "1" in the is_parent column, and all products must have the same group_id.
If a product does not belong to a group, leave the field empty.
To create a new product group, use any group_id that has not been used before. Example:
Pencils — is_parent = 1 (is it a group? Yes) — group_id = 56 (does it belong to a group? Yes, number 56).
Green pencil — is_parent = 0 (is it a group? No), group_id = 56 (does it belong to a group? Yes, number 56).
Red pencil — is_parent = 0 (is it a group? No), group_id = 56 (does it belong to a group? Yes, number 56).
Blue pencil — is_parent = 0 (is it a group? No), group_id = 56 (does it belong to a group? Yes, number 56).
Eraser — is_parent = 0 (is it a group? No), group_id = (does it belong to a group? No).
RUB, USD… — the following columns are optional and contain prices in the currencies used in the store (there are more than 80 currencies in total).
Important! You cannot add currency columns yourself. Select the currencies in the Store settings, export the table, and then change the values.
Important! The fields name, category, enabled and article (if is_parent = 0) are required.