Pro tip: easily find the issue we stated by pressing either the Ctrl + F or Cmd + F key.
Make sure the first column is in the correct order: first GTIN code(s), followed by MPN Code(s), other code(s), brand name and lastly, product name. Columns entered after these (Tags, Attributes and Retailer Assortments) are not mandatory to use in a specific order.
It should be an Excel format
This message indicates that the file you attempted to upload exceeds the maximum allowed size limit of 5 MB. To resolve this issue, you can try reducing the file size. One effective method is to create a new Excel document and transfer the contents of your current file into it. To do this, simply open a new Excel file and then cut and paste all the content from the original file into the new one. This can sometimes reduce the file size, especially if the original file has accumulated excess formatting or hidden data that doesn’t automatically transfer over. After moving the content, save the new file and try uploading it again to see if it meets the size requirements.
Make sure the file you try to upload doesn’t contain any formulas. Typically, Excel allows you to use Vlook-up formulas and such, which will conflict with Product Management. We recommend creating an upload file in which you first paste your input without values. Formulas will be gone immediately, and as an extra, the file will greatly reduce in size!
Since GTINs are globally used and registered, please be aware we will always validate these on authenticity. Every product should officially have 1 GTIN. There are variances in structure, like barcodes using GTIN-8, GTIN-12 (used mostly for UPC barcodes), GTIN-13 (ISBN), or GTIN-14 (wholesale). Not sure what the GTIN of your product(s) is? Then, please note that uploading a product with a GTIN is not mandatory, although it helps you enormously with mathing the product on different eCommerce channels.
The system can’t process any product using an MPN code consisting of 2 or fewer characters.
In Sitelucent, we suggest you use keywords and/or small phrases for attributes and Tags. We therefore give you a maximum of 500 characters per tag value and 2000 character room for Attributes.
Maximum number of Attributes or Tags (columns) used in Product Management
You can use a maximum of 20 tags and 20 attributes in Product Management. Per column, you are allowed to use 50 characters to create labels. Spaces and special characters are allowed. There is no cap on the amount of retailers in your account; this is according to your license.
Product Management contains lists of products that will be shown in various reports and dashboards across many retailers. To know which product(s) you want to track and match with these channels, using a set of identifiers is mandatory. The more the merrier, but please use at least one GTIN code or MPN code, or another code. A combination is always best since channels are likely not consistent in listing the identifiers on their Product Detail Page. Every product should always have a Product Name (which you can always structure or update via the Product Name Composer) and a brand name (e.g. Samsung, Crocs, JBL).
The list of products is uploaded successfully but contains conflicts. Below are the most common reasons and proposed resolutions to resolve.
Product A matching <GTIN> Product B
Product A matching <MPN> Product B
Product A matching <OTHER> Product B
Merge: A (in most cases the proposed action)
New line: B
Delete A or B: C
This likely happens when a list of products uploaded missing specific tags/attributes that were part of a saved filter, personal default, widget (dimension) and/or DCC module. Either delete or contact the owner of the artefact (s).
USER is the owner of X > can delete immediately
USER Is partially owner of X > needs to get partial permission first
USER is not the owner of X > needs full permission
Based on that, see below diagram:
these are the cases for TAGS / ATTRIBUTES / RETAILER ASSORTMENTS. There are situations for USERS / DASHBOARDS / INSTANCE X
You’re trying to upload a list with, for example, Bol NL [1], while you don’t have access to this retailer in your account. You can correct the file you attempted to upload or notify your customer success agent.
When you try to delete a tag or an attribute that is still used somewhere, you’ll receive an error. Most often, tags or attributes are than still used in for example a saved filter, dimension, widget or something else.
