The Excel Category Sheets template simplifies the process of preparing product data for upload. Designed to handle large inventories, it reduces the effort of repetitive data entry while ensuring accuracy. Dynamically generated based on the seller’s product categories, the template includes pre-filled details and dropdown options that make it easy to navigate and complete.
The spreadsheet has four key sections:
- Usage Guide sheet: Offers instructions on how to use the file. It also includes a "table of contents" listing all the dynamically generated category sheets.
- Missing Category sheet: Allows you to assign uncategorized products to the correct categories. Editing this is optional and can be completed anytime.
- Category sheets: Correspond to specific product categories and allow sellers to input details for their products. Category sheets are auto-generated, meaning it depends on your existing categories.
- Data sheet: A locked sheet containing reference data for consistent inputs. No action is required here.
Download the bulk upload template
- Go to Products > Bulk Upload Products from the left nav dashboard.
- Select Generate beside Excel Category Sheets.
- After the system generates the sheet, click the Download button.
- Save the file to your local device.
After saving the file, edit it on your local device. Learn more.
Upload the updated Excel file
- Go to Products > Bulk Upload Products from the left nav dashboard.
- Scroll down to the Upload a spreadsheet section.
- Click the Upload File button and select your updated Excel file.
- Wait for the system to validate the file.
Confirm the upload
After uploading the file:
- The system will validate the data and display a confirmation message for successful uploads.
- If errors are detected, the system may provide an error report specifying the issues.
Related articles