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:
    1. InternalName, which represents the ID field for the category
    2. Name_<languageCode>, which represents the category name in multiple languages
    3. Description_<languageCode>, which represents the category description in multiple languages
  • The item category Excel file must contain these header values in sequence:
    1. InternalName, which represents the ID field for the category
    2. ItemNumber, which represents the ID field for the item
  • The order guide Excel file must contain these header values in sequence:
    1. OrderGuideName: Specify the name of the order guide
    2. Notes: Optionally, specify the header notes for the order guide.
    3. CustomerNumber: Specify the customers who use this order guide. If multiple customers use the guide, then specify each customer number in a separate cell.
    4. 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.