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
<TAG> IS USED IN <INSTANCE: SAVED FILTER> (and is used on <DASHBOARD(S)>)
(<Dashboard> and) <saved filter> owned by <USER other than you>? show: contact this <user>
(<Dashboard> and) <saved filter> owned by <DIFFERENT USERS>? show: contact user x <saved filter> and contact z <dashboard(s)>
(<Dashboard> and) <saved filter> owned PARTIALLY by <DIFFERENT USERS>? show: contact user x <saved filter>or contact user access to <dashboard> before you can delete
All owned by you? let user DELETE SAVED FILTER directly. If that saved filter is not used in any dashboard, then just delete that saved filter (ID). If that saved filter is used in a dashboard, delete that saved filter and use the normal filter set up (first retailer in list is shown as default)
<TAG> IS USED IN <INSTANCE: PERSONAL DEFAULT> ON <DASHBOARD(S)>
<Dashboard> and <personal default> owned by <USER other than you>? show: contact this <user>
<Dashboard> and <personal default> owned by <DIFFERENT USERS>? show: contact user x <personal default> and contact z <dashboard>
<Dashboard> and <personal deafult> owned PARTIALLY by <DIFFERENT USERS>? show: contact user x <personal default> or contact user access to <dashboard> before you can delete
All owned by you? let user DELETE PERSONAL DEFAULT. that personal default is always linked in one or more dashboards. When delete, then use the normal filter set up (first retailer in list is shown as default) or the default saved filter that is in use for that dashboard.
<TAG X> IS USED IN <PRODUCT NAME COMPOSER>
System admin? navigate to product name composer (second tab?)
Not system admin? Contact user x
<TAG X> IS USED IN <ALERT>
owned by <different user>? contact this user
owned by you? change alert (second tab?) or directly DELETE ALERT
<TAG X> IS USED IN <SCHEDULED EXPORT>
owned by <different user>? contact this user
owned by you? change scheduled export (second tab?) or directly DELETE SCHEDULED EXPORT
TAG X IS USED IN <PRODUCT SELECTION> Can’t happen, product selection should always be (via utilities) on RA
ATTRIBUTE X IS USED IN <DCC>
System admin? Make direct changes in DCC (DEEPLINK TO DCC?)
Not system admin? contact system admin <x>
ATTRIBUTE/TAG X IS USED IN <DASHBOARD as RSP (ATTRIBUTE) or Dimension (TAG) >
<Dashboard> owned by <USER other than you>? show: contact this <user>
<Dashboard> by you? Navigate to that dashboard (DEEPLINK?) and let user make changes. Let them do actions like DELETE WIDGET in dashboard, CHANGE OVERRIDE DIMENSION, or let them DELETE the RSP > so that the RSP field will be blank in the widgets (table widgets / line / bar widgets)
ATTRIBUTE X IS USED IN <PRODUCT NAME COMPOSER>
System admin? MAKE CHANGES HERE (second tab)
Not system admin? Contact user x
<Y> / RETAILER > a retailer can’t be deleted by a user. Hence, it’s out of scope.
