Prepare CSV Source Data Files
Prepare Product data for the CSV Source Platform using the required products.csv filename, 43-column schema, and record structure.
Prepare CSV Source Data Files
Section titled “Prepare CSV Source Data Files”When CSV is selected as the Source Platform, Next-Cart reads standard Product data from products.csv through File Upload. If the file matches the Next-Cart structure documented here and the requested handling is within supported scope, choose Standard Migration or Managed Migration. A non-standard file that Next-Cart must process directly requires Custom Migration and the relevant Data Import Custom Job.
Use the field names, field order, and row structure defined below. Change the Product values without changing the structure that Next-Cart uses to recognize records.
File scope
Section titled “File scope”This is the standard Product template for the CSV Source Platform. It does not establish standard support for separate Customer, Order, or other entity files. Non-standard import structures and additional entity requirements are assessed individually through Custom Migration and the applicable Custom Jobs.
If the file structure or requested outcome is outside this standard Product template, do not assume that renaming the file makes it compatible. Prepare Custom Migration Requirements for the additional work before execution.
Download the sample file
Section titled “Download the sample file”Download the CSV Product sample as the starting structure. This downloadable example contains two illustrative Product variants. Replace all sample records with your own Product data, keep the 43-column structure, and save the upload as products.csv.
Required CSV structure
Section titled “Required CSV structure”| Requirement | Required format |
|---|---|
| Source Platform | CSV |
| Migration Service | Standard Migration or Managed Migration for this exact standard Product structure; Custom Migration when custom file processing is required |
| Standard supported file scope | Products |
| Connection method | File Upload |
| Filename | products.csv |
| Encoding | UTF-8 |
| Record layout | One header row followed by one Product or Product-variant record per row |
| Columns | 43, in the required order |
The first row must contain these headers in this order:
product_id,sku,price,status,weight,length,width,height,manage_stock,qty,name,description,short_description,barcode,manufacturer,categories,images,option_name_1,option_value_1,option_name_2,option_value_2,option_name_3,option_value_3,attribute_name_1,attribute_value_1,attribute_name_2,attribute_value_2,attribute_name_3,attribute_value_3,attribute_name_4,attribute_value_4,attribute_name_5,attribute_value_5,attribute_name_6,attribute_value_6,attribute_name_7,attribute_value_7,attribute_name_8,attribute_value_8,attribute_name_9,attribute_value_9,created_at,updated_atDo not rename, remove, add, or reorder columns. When a field has no value for a record, leave the field empty and keep the column in place.
Supported Product fields
Section titled “Supported Product fields”| Field group | Fields |
|---|---|
| Product identity, pricing, status, dimensions, stock, and content | product_id, sku, price, status, weight, length, width, height, manage_stock, qty, name, description, short_description, barcode, manufacturer, categories, images |
| Product options | option_name_1, option_value_1, option_name_2, option_value_2, option_name_3, option_value_3 |
| Product attributes | attribute_name_1 through attribute_name_9, paired with attribute_value_1 through attribute_value_9 |
| Timestamps | created_at, updated_at |
Format Product records
Section titled “Format Product records”- Use one row for each Product or Product-variant record.
- Variants of the same Product can use the same
product_idwith differentskuand option values. - Keep every option name/value pair aligned by suffix, such as
option_name_1withoption_value_1. - Keep every attribute name/value pair aligned in the same way. Leave unused pairs empty instead of deleting their columns.
- In
categories, separate multiple category entries with commas and use>for a hierarchy, such as Mobile > Phones. - In
images, separate multiple image URLs with commas. - Because CSV uses commas as delimiters, enclose any value containing commas in double quotes so the value remains in one field.
- Use numeric 0 or 1 values for
statusandmanage_stockrather than text labels. - Use
YYYY-MM-DD HH:MM:SSforcreated_atandupdated_atwhen timestamps are provided.
Prepare the file
Section titled “Prepare the file”- Create or open
products.csv. - Place the required 43-field header on the first row in the exact order shown above.
- Enter one Product or Product-variant record per row.
- Keep unused fields empty without removing columns.
- Check comma-containing values, including category lists, image lists, and descriptions, and quote them where required by CSV syntax.
- Save the file as UTF-8 comma-delimited CSV with the filename
products.csv. - Reopen the file and confirm that every record still contains 43 fields aligned to the header.
Verify before upload
Section titled “Verify before upload”| Check | Pass condition |
|---|---|
| Filename | products.csv |
| Header | All 43 field names are present in the required order. |
| Record structure | Every Product or variant occupies one row under the same header. |
| Empty values | Empty data does not remove or shift a column. |
| CSV quoting | Values containing commas remain a single field. |
| Options and attributes | Each numbered name/value pair remains aligned. |
| Timestamps | Supplied timestamps use YYYY-MM-DD HH:MM:SS. |
Store identity for file-based migrations
Section titled “Store identity for file-based migrations”CSV does not require a Source Store URL. When the Target setup provides Store URL, that Target Store URL becomes locked after the required Source and Target setup is successfully connected and the customer proceeds with Continue to Configuration. Later migration activity can use another valid products.csv file, including one prepared from a different originating store, but it must keep the locked Target Store.
See Store URL Locking and Store Identity for the complete rule.
If Product progress is 0/0
Section titled “If Product progress is 0/0”For a standard-template import, a 0/0 Product result means Next-Cart did not recognize Product records from the uploaded CSV structure. If the project instead uses an approved custom import structure, compare the upload with that job’s agreed input requirements rather than forcing it into this standard template.
For the standard template, check the filename, header names, column order, delimiter, quoting, and row alignment. Correct the file and upload it again. If the standard-template checks pass but Product progress remains 0/0, use Troubleshoot Connection Setup and provide the filename, a privacy-safe example row, and the migration result.
File Upload is migration input, not recurring synchronization
Section titled “File Upload is migration input, not recurring synchronization”Selecting CSV provides a file-based Source for a migration. It does not create a recurring synchronization feed between the file and the Target Store. The standard CSV workflow recognizes Products from products.csv when the required Next-Cart structure is used.
For a non-standard Source file that must be processed without conversion to this template, or for additional entities, repeated-feed handling or unsupported business logic, prepare a Custom Migration request and identify the relevant Data Import Custom Job.
Next Steps
Section titled “Next Steps”Continue with Upload Source Data Files to prepare and validate the exported files for the Source connection.