Retailer can integrate with NielsenIQ BookData to import product information from their database. This can streamline the process of creating a Book Stock Item.
Setup API details
Contact NielsenIQ BookData to request a Username and Password for API Access HERE.
Enter API Details in Retailer
- From the main screen of Retailer, click on Setup → API Connection.
- In the list of connections on the left hand side, click on the Nielsen icon
- Enter your Nielsen Username and Password.
- Click Save.
Note: For stores with multiple locations, this will need to be done at each store.
Book Department Setup
Each department that contains Book stock items, must be set in order to use Nielsen.
- From the main screen of Retailer, click on Stock Maintenance → Suppliers & Departments.
- Click on the Magnifying Glass 🔎︎ button and select your books department.
- Tick the box This Department has stock items with Authors? (eg. Books).
- Press Save.
- Repeat on other Book Departments if you have more than one.
- Once finished, close and reopen Retailer.
Setup External Feed Settings
The External Feed Settings control if Nielsen can be used from the Add Stock Wizard and Stock Screen.
- From the main screen of Retailer, click on Setup → Stock → External Feed.
- Down the left hand side, click Nielsen Bookdata.
- In the Stock Screen section, choose between:
- Disable - Nielsen will not be used in the Stock Screen
- Enable for all products - Nielsen can be used for all Stock Items
- Enable for Books Only - Nielsen can only be used for Stock Items in a Book Department. See above.
- In the Stock Wizard section, choose between:
- Disable - Nielsen will not be used in the Add Stock Wizard.
- Enable - Nielsen will be used in the Add Stock Wizard.
- In the Import Stock Images section, choose between:
- Disable - Images will not be imported from Nielsen.
- Enable - An Image will be imported from Nielsen (if available).
- Down the left hand side under Common Settings, click Options.
- For Extra Details Destination, choose between:
- Web Description - Product Description from Nielsen will be added to the Web Description field only.
- Extra Description - Product Description from Nielsen will be added to the Extended Description field only.
- Web and Extra Description - Product Description from Nielsen will be added to both the Extended and Web Description fields.
- Click Ok.
Using Nielsen in the Add Stock Wizard
- From the Stock Screen or Find Stock Screen, click the Add button. The Add Stock Wizard will open.
- In the Enter Barcode and PLU screen, scan or type in the product's barcode.
- Click Next or press Enter twice.
- In the External Feed Results page, the grid view will show multiple columns depending on what External Feeds are available.
- For any External Feed, click a data point to highlight it blue. At the top of the grid, click a External Feed name in the Source column to highlight all data points from that source.
- Once the data points you wish to use are highlighted, click Next.
- Continue with the Add Stock Wizard. The highlighted data points will be prefilled in the Wizard.
Using Nielsen in the Stock Screen
- From the main screen of Retailer, click on Stock → Stock Screen or click Stock Maintenance → Stock Screen.
- Click the Magnifying Glass 🔎︎ button to open the Find Stock Screen. Select the item you wish to use with Nielsen.
- In the Stock Screen, click the External Feed tab.
- The grid view will show multiple columns depending on what External Feeds are available and a 'Stock Data' column which shows the current data of the Stock Item.
- For any External Feed, click a data point to highlight it blue. At the top of the grid, click a External Feed name in the Source column to highlight all data points from that source.
- Once the data points you wish to use are highlighted, click the 'Save External Feed Details to Stock Item' button.
Nielsen data points
The following data points can be imported from Nielsen:
- Title as Retailer Description
- Author
- Sell Price
- Annotation as Retailer Extended and/or Web Description
- Supplier
- Images