Using data uploads, you can send your own CSV / XLSX file (even zipped) into a specific partition.

...

The following partition entities can be updated using data uploads: 

• BoM DataData Source

• Company Parameters

• Competition Data

• Condition Records

• Customer

• Customer Extension

• Product

• Product Extension

• Product Competition

• Product Reference

• Company Parameter

• Price List (both Simple and Matrix) – Data Source

• Live Price Grid (LPG) – only overridable fields are supported for update

• Live Price Grid Matrix

• Manual Price List Live Price Grid (LPG) – – only overridable fields are supported for update

• Matrix Price List – only overridable fields are supported for update

• Price Lists

• Product

• Product Extension

• Product Reference

• Seller

• Seller Extension BoM Data

• Users (to import users to a partition)

...

• CSV
  Files which contains the BOM character are also supported.

• XLSX if they meet the following criteria:

  • The file has only one sheet.

  • The data start in the first cell of the first column.

  • The first row is a header.

  • No macros are present in the file.

  • No formulas are present in the file.

  • Maximum size 20 MB.

All of these files can also be zipped. 

The preferred file encoding format is UTF-8; maximum file size is 512 MB.

...

In addition, there is the Upload Queue section which shows you a list of all running/waiting Data Uploads to the partition and you can stop or cancel the upload there.

Validation

The following types of validation take place:

• Before data upload – If the CSV / XLSX file has correct types String, Number, Date and DateTime. In case of an error, the file is not uploaded and the affected lines are displayed.
  
  

• During data upload – If the business key length is within limit. You have the option to restrict the length of individual attributes used in the business key or reduce the number of used attributes.