How Do I Bulk Download/Upload Product Settings For All My Products?

SellerLegend enables efficient management of product settings across hundreds or thousands of SKUs through bulk Excel upload/download functionality.

INFO

Product settings are managed per marketplace — the process must be repeated for each one individually.

Step 1: Download the Product Settings Template

1. Navigate to Products and Inventory → Products List
2. Click the Import/Export button (next to Getting Started)
3. In the EXPORT section:
   • Select PRODUCT SETTINGS AND ATTRIBUTES as the report type
   • Choose the account/marketplace under Account ID
   • Optionally check "Don't export hidden/ignored products"
   • Click Export
4. Go to Reports → Exported Reports
5. When STATUS shows DONE, click the 3-dot menu and select Download to save the Excel file

Step 2: Edit the Downloaded Excel File

1. Open the file in Excel or another compatible application
2. Update the settings you wish to change
3. Save your changes in the Excel sheet

TIP

Default values are prefilled on first download. Newly added products may appear with default values.

Step 3: Upload the Modified Excel File

1. Navigate to Products and Inventory → Products List
2. Click the Import/Export button
3. Under the IMPORT section:
   • Select PRODUCT SETTINGS AND ATTRIBUTES
   • Choose the same account as the export
   • Click "Choose File" and select your edited Excel file
   • Click Import
4. Go to Reports → Imported Reports to monitor progress

Error Handling

If the import status shows DONE_WITH_WARNINGS, download the report to review errors:

• Problematic fields will be highlighted in red
• Hover over the red fields to see Excel comments with error descriptions
• Correct the errors and re-upload until resolved

Excel File Field Definitions

Required Fields

Field	Column Name	Format
Product SKU	product_sku	Must match existing SKU
Stockout Alert Days	alert_days	Positive integer
Stockout Alert Units	alert_units	Positive integer
Restock Lead Time	restock_lead_time	Positive integer
Stock Days Of Cover	days_of_cover	Positive integer
Safety Days	safety_days	Positive integer
Minimum Order Quantity	moq	Positive integer
Units In Transit	in_transit	Positive integer
Units In Warehouse	in-warehouse-qty	Positive integer
Crate Quantity in Units	crate_quantity	Positive integer
Crate Quantity Behaviour	crate_behaviour	"Round up" or "Round down"
Sales Velocity Period	sale_velocity_days	7_days, 14_days, 30_days, 90_days, 180_days, 360_days
Discount Threshold (%)	discount_threshold	Decimal (0.5 = 50%)
Excessive Quantity Threshold	excessive_quantity_threshold	Currency value
Natural Daily Sales Velocity	natural_daily_sales_velocity	Decimal

Optional Fields

Field	Column Name	Format
Product ASIN	asin	Reference only
Internal Name	internal-name	Created if absent
Product Group	product_group	Created if absent
Tags	tags	Comma-separated; new tags created automatically
Hide Product	hide	1 to hide, 0 to show
Stockout Notification Flag	notify_stockout	1 to notify, 0 otherwise
Non-Sellable Returns Notification	accept_returns	1 to notify, 0 otherwise
FBM Shipping Cost	shipping_cost	Currency value
Miscellaneous Cost	miscellaneous_costs	Currency value
Internal Price	Internal Price	Currency value

WARNING

The file must include a header row with the exact titles shown above. All required fields must be populated.