Stewardship Data Management User Guide

(1)

Stewardship Data

Management User Guide

(for Data Provider)

(2)

Stewardship Data Management User Guide

The information contained in this document is privileged and confidential and may otherwise be exempt from disclosure under applicable law. Use of the information in this document is for the designated recipient only and any dissemination, distribution or copying of this material by any entity other than the designated recipient is strictly prohibited without the express written consent of GS1 Canada.

If you obtain access to GS1 Canada information that is not intended for you, please notify GS1 Canada immediately.

Information in this document is subject to change without notice.

Product names mentioned herein may be trademarks and/or registered trademarks of their respective companies.

Published in Canada December 2013

GS1 Canada

1500 Don Mills Road, Suite 800 Toronto, Ontario, M3B 3L1 P 416.510.8039

P 1.800.567.7084 F 416.510.1916

(3)

Introduction

This document describes how to use ECCnet ProSYNC® to include packaging information for private label products for stewardship purposes.

There are two ways that you can manage packaging data:

 Mass Upload: Manage data for multiple GTINs in a Microsoft Excel spreadsheet and upload into the system

 Stewardship (Packaging) Panel: Manage data for an individual GTIN in the Product Information page

Mass Upload

The Mass Upload tab for Stewardship functions is available only for data providers who have loaded private label GTINs for participating data recipients.

To use the Mass Upload method, you must have Microsoft Excel installed on your local

computer so that you can edit and compare packaging attributes for multiple existing products. 1. Log in to ProSYNC (www.eccnet.profilesys.ca).

The ProSYNC Product tab is selected. 2. Select the Mass Upload tab.

3. Select Stewardship.

Step-by-step instructions appear to help you with the process. 4. Follow the instructions to download the Mass Upload data template.

A Microsoft Excel spreadsheet appears, similar to the screenshots below.

(5)

Mass Upload

Figure 2. Mass Upload template showing some packaging data columns.

In this spreadsheet, use the values in columns B to L to help identify the product. Changes that you make in columns B to L are not saved to your database. 5. Save the Mass Upload file on your computer.

6. In the spreadsheet, choose a product and do the following:

a) In the Action column, select the cell. A down-arrow button appears to the right of the cell.

b) Click the arrow button and select appropriate action from the drow-down box: Add, Update or Delete. If you leave this value blank, no action is taken on this product. c) To add stewardship data, specify packaging material values in the appropriate

columns.

d) To update stewardship data, revise packaging material values in the appropriate columns.

e) To delete stewardship data, just choose “Delete” in the Action column. Note: For Packaging Material Effective Date, use the format mm/dd/yyyy. 7. Save the Mass Upload file.

8. To manage stewardship data for another product, repeat steps 6 and 7.

9. In the Stewardship – Mass Upload tab, follow the instructions to upload the saved Mass Upload file with stewardship data.

10. The amount of time this action takes depends on the size of the file. The upload process includes validation of the data.

After the upload process is complete, you receive an email notification. If you do not receive a notification for this action, talk with your system administrator.

View Results of a Mass Upload

To view results of the upload, including any validation errors, in ProSYNC do the following: 1. Select the Reports tab.

2. Click your company name. The Audit Trail page appears.

3. In From Date and To Date, specify the start and end of a range of dates. 4. In Report Type, specify “Mass Upload Report”.

(6)

5. To reduce the size of the report, in Status, select a status value. The report will show only those events with the selected status value. 6. Click Go.

The report appears in the lower part of the page, similar to the example in Figure 3 below.

(7)

Stewardship (Packaging) Panel

The Stewardship (Packaging) panel is available only for data providers who have loaded private label GTINs for participating data recipients. The Stewardship (Packaging) panel appears on the product details page.

The benefit of this method – compared to the Mass Upload method – is that it is easy to find individual products using Search. As well, you can focus on managing packaging attributes one product at a time.

Managing Stewardship Data for an Existing Product

1. Login to ProSYNC (www.eccnet.profilesys.ca). The Product tab is selected.

2. Search for a private label GTIN.

The quickest way to look up a product is to specify the product GTIN and click Search. The Search Results/GTIN Publication page appears, showing a list of GTINs that match the search criteria.

3. In the list, click the GTIN for a product. The product details page appears.

4. Scroll down to the Stewardship (Packaging) panel.

This panel shows a list of packaging material effective dates with the most recent date at the top of the list.

5. You can perform the following tasks:

View or Edit Packaging Materials Details for an Effective Date

a) Click Expand next to an effective date. The list of packaging components appears, showing details for each component.

b) Make revisions to field values as required.

c) To collapse the details, at the top of the list, click Hide. d) If you made changes, click Save. Changes are saved. Add a Packaging Material Effective Date

a) At the bottom of the list of effective dates, enter a date in the next blank field. b) Click Expand. Space appears to add details for up to five packaging components. c) For each packaging component, complete the appropriate field values. See the list of

required fields below.

(8)

Delete a Packaging Component

a) Click Expand next to an effective date. The list of packaging components appears, showing details for each component.

b) Clear all field values in a component.

c) To delete a packaging material effective date entry altogether, clear all field values in all components and then, in Packaging Material Effective Date clear the date value. d) Click Save. Components are deleted.

For help with field descriptions, see the Stewardship Attributes List document. 6. If this GTIN is ready to be released to your trading partners, click Save and Approve. For help with publishing or with adding a product, see the ECCnet ProSYNC User Guide.

(9)

Stewardship Data Management User Guide