Required fields:
| Excel Column Header | Field Descriptions and Valid Values |
| results | Leave this field blank. It will automatically populate if you upload the file using the Solid Commerce Excel Add-In Tool. |
| product custom sku | The SKU of your product. |
| warehouse id | The Warehouse ID of your product. |
| warehouse name | Identifies the warehouse list where the product is located |
| exclude from inventory alerts | Turns low inventory alerts for this product on or off completely. If the value specified is true then the product will be excluded from all levels of inventory alerts The following values can be used to turn alerts on: 1, true, yes (case insensetive). The following values can be used to turn alerts off: 0, false, no (case insensetive) |
| enable low inventory alerts | Turns product level low inventory alerts for this product on or off. The following values can be used to turn alerts on: 1, true, yes (case insensetive). The following values can be used to turn alerts off: 0, false, no (case insensetive). If the value for the "exclude from inventory alerts" is true that this field will be ignored |
| low inventory alert warning threshold | Specified the warning threshold for low inventory alerts for this product. The threshold must be an integer number greater than 0. If the value for the "exclude from inventory alerts" is true that this field will be ignored. Required if the value in the "enable low inventory alerts" field is true. |
| low inventory alert critical threshold | Specified the critical threshold for low inventory alerts for this product. The threshold must be an integer number greater than 0 and must be lower than warning threshold. If the value for the "exclude from inventory alerts" is true that this field will be ignored. Required if the value in the "enable low inventory alerts" field is true. |
Uploading Your Spreadsheet:
Using the Solid Commerce Excel Tool, click on Upload Data >> Enter your credentials >> Check on Upload Product >> Click Confirm
How the fields map between Excel and the UI:
NOTE: You can also retrieve inventory alert values with the excel tool
Related Articles
- Using Low Inventory Alerts
- Upload Low Inventory Alerts through Webuploader (article not created)
Comments
Please sign in to leave a comment.