Uploading products from a spreadsheet
TL;DR
This page covers adding many products at once from a spreadsheet, and reviewing past uploads. Rows that cannot be read are skipped rather than stopping the file, so always check the upload history afterwards to see what did not go in.
What this is for
Adding many products at once from a spreadsheet file, instead of typing them one at a time. Each file row becomes one product; rows that fail are skipped, logged with the reason, and the rest carry on.
Before you start
- The upload is not in the main menu. It lives on the Product list: the Upload button opens the "Upload Product" window, and Upload History opens the log of past uploads. Both appear only for readers allowed to use them.
- The file must be a CSV, a plain comma-separated file, not an Excel workbook. Excel can save as CSV.
- Any carton sizes and units of measurement the file mentions must already exist and be active, so set those up first.
Uploading the file
-
On the Product list, select Upload. The "Upload Product" window opens with two parts: "Select File" and "Download Demo File".
-
Select Download Template to fetch the sample file. Its heading row, exactly:
Product Name,To The Order Name,Is Fixed Carton YesNo,Carton Size,Unit of Measurement,HSN Code, GST Percentage -
Fill one row per product:
| Column | What it must contain |
|---|---|
| Product Name | Required, up to 255 characters, not already used by another product |
| To The Order Name | Required, up to 255 characters |
| Is Fixed Carton YesNo | Exactly "Yes" or "No" |
| Carton Size | Required when the previous column is "Yes". Must match an existing carton's size text exactly: the size, not the carton's name |
| Unit of Measurement | The unit's exact text, and that unit must be active |
| HSN Code | Digits only |
| GST Percentage | A number above 0, up to 100 |
- Choose the file under "Select File" and select Submit ("Reset" clears the choice, "Cancel" closes the window).
- The result comes back as one message. Quoted exactly as the system writes them:
- all rows good: "12 Products has been uploaded successfully"
- a mixture: "12 Products has been uploaded successfully & 3 Products has been failed to upload."
- all rows bad: "All 3 Products has been failed to upload "
There is no limit in the upload itself on row count or file size. The only rule the screen enforces is the CSV type. Very large files are limited only by what the server accepts.
When a row cannot be read
The row is skipped and every other row still processes. Nothing stops mid-file. The skipped row is written to the upload history with the status Failed. A "Reason" column lists everything wrong with it. Several problems appear together, separated by commas, using the same messages as the product form. For example: "Please enter product name., HSN code must contain only numbers.".
A row that names a carton size or unit that does not exist fails with "The selected carton size is invalid." or "The selected unit of measurement is invalid.".
Errors you may see
| What happened | Message |
|---|---|
| Submit with no file chosen | "Please select a file to upload." |
| File is not a CSV | "Failed Uploading File! File Type must be CSV." |
| A row's name is already taken | "Product name already exists." (in that row's Reason) |
| A row's carton size matches nothing | "The selected carton size is invalid." |
| A row's unit matches nothing active | "The selected unit of measurement is invalid." |
| The upload itself fails | "Something went wrong. Please try again later." |
Reviewing past uploads
Upload History (from the Product list) opens a screen headed "Upload History", with one row for every spreadsheet row ever uploaded, successful or failed, not one per file. Columns: ID, File Name, Product Name, Fixed Carton, Carton Size, Unit of Measurement, GST Percentage, Status, Reason, and a view action showing the row in full. Failed rows carry their reasons; successful rows show a dash there. Search by file name to see one upload's rows together.
What happens behind the scenes
- Every file row is written to the history first, then the good ones become products. The history is the complete list, including what never made it in.
- Products created this way behave exactly like hand-entered ones, including the copy-at-order-creation behaviour described on the Product page.
- The file's rows are checked with the same rules as the product form; nothing extra is forgiven or enforced.
FAQs
Why can't I find the upload in the main menu?
It is not there. The upload lives on the Product list: the Upload button opens the "Upload Product" window, and Upload History opens the log of past uploads. Both appear only for readers allowed to use them.
Can I upload my Excel workbook directly?
No. The file must be a CSV, a plain comma-separated file, not an Excel workbook. Excel can save as CSV.
Some rows did not go in. How do I find out which ones and why?
Open Upload History from the Product list. Skipped rows appear there with the status Failed, and a Reason column lists everything wrong with each one, using the same messages as the product form.
Will one bad row stop the whole file?
No. The bad row is skipped and every other row still processes; nothing stops mid-file. The skipped row is logged in the upload history with the reason.
Why does the Carton Size column keep failing even though the carton exists?
The column must match an existing carton's size text exactly: the size, not the carton's name. A row that matches nothing fails with "The selected carton size is invalid.".
Is there a limit on how many rows I can upload?
There is no limit in the upload itself on row count or file size; the only rule the screen enforces is the CSV type. Very large files are limited only by what the server accepts.
Related pages
- Product: the fields these columns fill
- Carton: where the size texts must already exist
- Unit of Measurement: where the unit texts must already exist
Last verified: 31 July 2026
No comments to display
No comments to display