Bulk update considerations
- Only one instance for each file type is validated and published at any given time.
- Queuing is supported on both validating and publishing. This means that multiple files are uploaded sequentially and validation is moved to the next file after the current file is finished.
- Downloading a copy of validated upload files, with annotations on any encountered errors, is supported.
- User can validate a file with a maximum of 2,000 records for category file type and 150,000 records for category item file type. Headers are excluded in these counts.
- A maximum file size of 2MB is acceptable for upload.
- The category Excel file must contain these column header values in sequence:
- InternalName, which represents the ID field for the category
- Name_<languageCode>, which represents the category name in multiple languages
- Description_<languageCode>, which represents the category description in multiple languages
- The item category Excel file must contain these header values in sequence:
- InternalName, which represents the ID field for the category
- ItemNumber, which represents the ID field for the item
- The order guide Excel file must contain these header values in sequence:
- OrderGuideName: Specify the name of the order guide
- Notes: Optionally, specify the header notes for the order guide.
- CustomerNumber: Specify the customers who use this order guide. If multiple customers use the guide, then specify each customer number in a separate cell.
- ItemNumber: Specify the items in the order guide. Specify each item in a separate cell.
- Header values are case insensitive.
- The language codes that you specify in the upload files must be exactly the same as the language codes maintained in the Business Center.
- If no translation is provided for a certain language, then the translations provided for the default language are used instead.