Item Details data update via Import
This will update the color cards on the Item detail page.
- DEFAULT COLUMNS IN THE EXCEL SHEET
- MANDATORY COLUMNS FOR DATA
- FIELDS THAT CAN BE UPDATED
- ADDING OR UPDATING
See how to Import and where to select the type of Import: HERE
DEFAULT COLUMNS IN THE EXCEL SHEET
The following columns are the default ones - with a description of where to find the data.
Headers in Excel | Explanation |
Example of data |
BRAND: | The Item Brand name in the Item Header | |
ITEM NAME: | Item Name in the Item Header | |
ITEM NO: | Item No in the Item Header | |
STATUS: | Status in the Item Header | |
SUPPLIER ID: | Supplier ID can be found in Admin->Supplier under the respective Supplier company | |
COLOR ID: | Will be included in the Library color string | |
COLOR ID2: | Will be included in the Library color string (if ID2 is used) | |
LIBRARY COLOR: | Is found on Item->Details color card. Please see the illustration below | |
COLOR NAME: | Is found on Item->Details color card. Please see the illustration below. Is not related to the color library | |
COLOR REF: | Is found on Item->Details color card. Please see the illustration below. Is not related to the color library | |
COLOR APPROVAL: | Is found on the Item->Detail Comment pop-up. Please see the illustration below |
|
ACTIVE: | Is found on Item->Details color card. Please see the illustration below |
|
COLOR COMMENT: | Is found on the Item->Detail Comment pop-up. Please see the illustration below | |
COMBO NAME: | Is found on Item->Details color card. Please see the illustration below |
How to find color info on the Item->Detail subtab. When you add a Color to your Item Detail you can see this
![](https://knowledge.delogue.com/hubfs/Knowledge%20Base%20Import/s3.amazonaws.comcdn.freshdesk.comdatahelpdeskattachmentsproduction9146376440original7y2Ui2MNMJMTK6ANU3xfRwlScFIxe9oC2g.png)
And this is where you would find the Color Comment and the Approved. Still on the Item Detail subtab. Click on the small Comment icon and you can see both the Approval check box and the comment field.
![](https://knowledge.delogue.com/hubfs/Knowledge%20Base%20Import/s3.amazonaws.comcdn.freshdesk.comdatahelpdeskattachmentsproduction9146376818originalUBO0_4-lRjAtznThFFfCnu6gDGYSOYFy9w.png)
MANDATORY COLUMNS FOR DATA
These columns are mandatory to enter data in - if you don't do this - the import can not work.
- Brand
- Item Name
- Item No
- Supplier ID - if it is on your style it's mandatory
- Color Approval
- Combo Name
FIELDS THAT CAN BE UPDATED
With the update feature - it is possible to update the following fields:
- Color ID
- Color ID2
- Library Color
- Color Name
- Color Ref
- Color Approval
- Active
- Color Comment
ADDING OR UPDATING
If you are updating with a Combo Name that does not exist on your Item Detail it will be created.
You can set Color ID and Color ID2 if your company is using the option "Use this color library for items"
![](https://knowledge.delogue.com/hubfs/Knowledge%20Base%20Import/help.delogue.comsupportsolutionsarticles9000208397-item-details-data-update-via-importhit.gif)