PIMS (Product Information Management System) – 2020-09-22
Summary
We require a central database to house all our product information, making it easily accessible for all internal and external users. It must include all product information on Trader, product descriptions, fact and benefits and images. In addition to the database, we require a workflow tool to ensure that each piece of data needed is present and is correct.
The images below show the fields in Trader:
Main Inventory Page
Extended Page
Fields
Field
Source
Comments
1. Code
Trader
2. Description
Trader / Shapeshift
Decide which description to use for which function – website/price tickets/bar codes etc. The current description in Trader is not the one used on the website.
3. Full Description
Trader
4. Category
Trader
5. Sub-Category 1
Trader
6. Item Status
Trader
7. Item Brand
Trader / Shapeshift
I am not sure if the brand on the website is captured manually.
8. Selling Price
Trader
9. Promo Price
Trader
This comes from the promotions section and is loaded by Ronel.
10. Qty on Hand
Trader
Company level is OK for now but must accommodate store level in the future when we start e-commerce.
11. Qty on purchase order
Trader
We will use this in future to determine delivery times.
12. Supplier Lead time
Trader
This is from the supplier Masterfile and will assist us in determining delivery times in the future.
13. On Web Page
Trader
Tickbox
14. Image(s)
Currently with Shapeshift / CW
There has to be a minimum of one image per product, but there can be more (e.g. fridges open / shut). There must be an indication of the main picture – to be used first or when only one image is required. There is a function to include images in Trader but it slows everything down. Perhaps we could bring a thumbnail back into Trader or use Technorcore somehow.
15. Product Details (All)
Currently with Shapeshift / CW
A complete description of the product. This can be lengthy
16. Product Detail (Short)
New
A predefined number of lines for shorter use (grid view of the website, price tickets etc. This could also just be the first couple of lines of the field above.
17. Credit Terms
Calculated
Technocore do the calculation.
Workflow
Most of the fields will be created in Trader, but the system must ensure that all fields are complete and, in some cases, approved:
C:\Users\Dell\Dropbox@Work\Merchandise\PIMS.docx