Item Management 2019

Item details

Improved performance when opening item

Opening item/model from item grid is much faster, especially when scrolling down before opening a selected item.

Manage item generations
When opening manage item generations, we show available planning codes for given item/model. By default only “Current” planning codes are visible. In colors column we show which colors that are linked to the planning code, with specific colors or “All colors”.

Improved performance when searching in drop-down fields
When searching several times in register values in drop-down fields user should not experience slowness.

Validation of external item number

When models have duplicated items due to migration of data (same size & color), it is possible to update them, change size etc. Adding new items is still impossible, and will create error situations in import of PRICAT that must be handled by support.

Import

Import of item relations

Import of item relations is re-implemented to optimize further maintenance of the code. All of add/edit/remove related items works the same way. It is possible to remove related items reference with empty list, and the same for bundle content. For Excel import user needs to add parent item with empty value for content or add NULL value. It is not possible to add a related item which are in the same model, nor duplicates within same type or the same item. It is possible to add the same item for different relation types.

'Update items from file' in Import
'Update items from file' button is disabled for imports with status Imported. When status is Partially imported, only not yet imported items are updated.

Error handling for items without GTIN
Items can be added to a model where one of the items are missing GTIN.

Export to Excel

Inactive status and inactive date
Columns for inactive status and date for inactivating are added to export to Excel. To get inactive items exported to Excel the user must first select to view inactive items in the grid.

Item search

Improved performance when filtering on item number
Searching/filtering on (external) item number is faster.

Import

Improved error handling
When there is something wrong with an item import we create error for given item without affecting the whole batch of items. Error handling for PRICAT files with more than 10.000 items is also improved.

System

Date in UTC-format
The system handles dates in UTC-format for currency rate dates, delivery dates and season dates.

Import

PRICAT import: Fix item identifier when new items and update for same supplier model number

When importing new items and in the same import there are updates for existing items as well as same supplier model number and this files get 'item identifier' error, then from now all items get error. Until all 'item identifier' errors are fixed, it is not possible to import new items. They get error: Item identifier error. Supplier deviation for other variant.

Temalogic - compare price values in import.

Compare price values for Temalogic import
Import from Temalogic can be exported to Excel for comparison of existing price calculation values with values from the import file.

Item details

Saving models with many items

We have fixed performance issues related to item plannings and supplier details, and verified that models with 500 items can be modified and saved without problems.

Item search

Scrolling in item grid

Scrolling in item grid is improved to handle filtering with locked columns.

System

New design for Item Management

The Lindbak logo is replaced by the EG logo. Design is modified to use EG green color in the top bar.

Item search

Cost carrier column in item grid

Cost carrier columns added to item grid, directly after brand column and by default hidden. Filter on this column with default sorting can be done with good performance.

Item details

The first supplier on item is automatically set as main supplier

When adding supplier for the first time, it will be common and added as main supplier. When user goes back from 'item suppliers' (3rd level) grid, we have removed loading of item again, so it moves much quicker back to item details grid.

Import

Validation for currency in imports

Currency is validated in item imports preventing imports of currencies that are not existing in currency register. If a user imports an item that has a currency that does not exist, the validation will fail with the message "Unknown currency".

Import: All sizes are updated with new color even if they are not in the import file

When updating color in import, but not for all items, there will be displayed a warning 'Color for variant will be updated' and after the import the whole variant's color will be updated. For size validation still works as before.

Price calculation

Validation of price calculation fields

Validation has been added to the following fields:

• Wholesale price

• Recommended retail price

If invalid values are added to these two fields (0) the box will turn red. If a user still attempts to create a price with invalid values, a warning will be displayed at the top of the price calculation and the price will not be created.

Item details

Validation message if reaching highest value for external item number when adding new items

When creating new items and external item number is reaching it’s highest value, a validation message will be displayed both in “New item” and item import.

Error messages:

• Highest number for size in external item number, XXXXXXXXX990, is reached

• Highest number for color in external item number, XXXXXX999XXX, is reached

Show cost carrier
Fixed bug preventing cost carrier to be visible in item details.

Timeout when saving large models
After fixes it doesn't time out when saving values on model level or item-level to all items for large models (350+ items).

System

Change in database model: Attributes moved from model to item level
Supplier is defined per variant (item level in database).

Attributes 'Can be ordered', 'Country of Origin', 'Manufacturer' are saved on item-level. The user must now select to save these attributes to all items within the model.

Import

Handling of size issue between variants in same model

When there are colors or sizes which have for different colors/sizes same color/size number parts (Parts of external item number - 7-9 for color and 10-12 for size), item will be added with next possible value.

Mass update

Fix for mass update from Excel
Critical bug is fixed.

Price calculation

Time zone

When working with prices, the user will see dates in the configured timezone, and be able to see the prices as they will be effective in stores, without the users local time zone interfering.

Validation of mandatory price fields
When saving a price, user will be notified if wholesale price or recommended retail price is 0.

Mass update

Preventing new planning codes for items being created from mass update

If planning code in Excel file for mass update does not exists for given item, the validation will result in an Error, preventing the item planning from being created.

Price calculation

Create price: Warning when planning code deviation within model

When creating a new price the user will see which colors that do not contain the planning code, so the user will know beforehand which items will not contain the price.

Mass update

Preventing new items from being created from mass update

• When updating items from items grid with 'Update items from file' (excel), the file is handled as Pricat import and uploaded in the Import view.

• The user needs to open the file and confirm import - same as for Pricat import. 

• For now we have only one validation rule: Only existing items can be imported.

Import

Color can be removed in PRICAT file
Problem fixed: When removing color from imported PRICAT file, the imported items will be created without color.

Item search

Better performance when opening item grid

Performance tuning.

Item details

Item subgroup can be added to item
Problem fixed: No error message when saving after adding item sub-group.

Price calculation

Copy price triggers export of item

Copying a price triggers export of the targeted item and it's new prices.

System

Simultaneously import and export of the same items

Problem fixed: Ordering of items will be correct when doing mass update of the same items that is being exported (due to a previous mass update).