Using PCC Grainger Connector

Grainger is a leading e-commerce platform and following are the steps to set up the connector:

1. Once you log into PCC, click on Connectors from the drop-down list.

2. The new window that opens contains all the connectors available and when you click on View Details     icon in the Grainger section, the Description of the connector will show up.

3. To configure the Grainger Template, click on Set Configurations  icon in the Grainger section.

4. On the new window that opens, click on Add New Export Template icon on the top right-hand corner.

5. Now, the following screen opens where you must fill the necessary details and attach the template file.

6. Enter the Template Name.

7. Click on Browse  icon and browse to the location of the Grainger template file. Select the file and click on Open.

8. Once the file is selected, click on Upload .

9. You will get the following message if the file was successfully uploaded.

10. Now, the Remove File icon will get activated. In case you want to remove the file and upload a different file, you can click on Remove File icon.

11. Once you click on Remove File, the file will get deleted and the following screen will be visible.

12. Enter the Header Row Position. In our sample Grainger file, the Header Row Position is 10.

13. Once you fill up everything, click on the Next button at the bottom of the page.

14. Now, you will get the below message as PCC fetches the template fields.

15. On the new window that opens, you must select the catalog from the drop-down list.

16. Now, you have the option to map the attributes.

NOTE | It is not mandatory to map all the attributes.

NOTE | In the case of templates with multiple tabs, when you map an attribute to a field in one tab, the same attribute will get mapped to the same named field in the other tab.

You will find the following icons adjacent to the attributes:  

  - If this icon is enabled, it means that the attribute is present again in the same tab and/or in multiple tabs and making a change to the mapping will impact the attribute mapping in all the places.

 - This icon denotes whether the field is locked or not.

 - When you click on this icon, you will be able to view the List of Values for the attribute, if available, as shown below

 - When you hover on this icon, it will show you a brief description of the attribute as shown below

- When this icon is enabled, it means that the field has been mapped with an entity in PCC.

For some of the fields, the values will be populated by the system based on the values of another field and such fields are called ‘System Deduced’. For example, the field ‘Do you have a UPC?’ is populated based on the value of the field ‘UPC’ as shown below:

The following fields are System Deduced:

1. Do you have a UPC?

2. For Export

3. Any Reason Not to Sell?

4. Certificate of Conformity

5. Heavy Metal Content Indicator

6. SDS Indicator

7. FIFRA Indicator

8. HMIS Rating

9. VOC Information

10. California Prop 65 Cancer

11. California Prop 65 Reproductive Harm

12. California Prop 65 Warning Short Message Compliancy

13. Hazardous Material Flag

For the following fields, we will not be able to see the List of Values:

1. Country of Origin

2. NPI Restricted Countries

3. Product Restrictions – State

17. Once you have done mapping the necessary attributes, Click on Save Template.

18. The PCC Grainger Connector window opens, and you will find the newly added template as shown below.

19. You will have the following three options available for you next to your template:

    • - When you click on this icon, the following window opens where you will be able to edit your template details.

    • - When you click on this icon, you will be able to delete your template. Once you click on this icon, the following message pops up to requesting you to confirm if you want to delete it.

       

    • - When you click on this icon, your template will get downloaded into your system.

20. Select Catalog Exports from the drop-down list.

21. When the Catalog Exports window opens, click on New Export.

22. Now, you must choose the catalog from the drop-down list.

23. Once the window containing all the types of exports opens, click on Export under the Grainger Template Export.

24. Now, you must enter the Export Name.

25. Click on Browse icon and browse to the location of the Grainger export file. Select the file and click on Open.

26. Once the file is selected, click on Upload.

27. You will get the following message if the file was successfully uploaded.

28. Now, the Remove File icon will get activated. In case you want to remove the file and upload a different file, you can click on Remove File icon.

29. Once you click on Remove File, the file will get deleted and the following screen will be visible.

30. Enter the row from which the Header Starts in the file. In our sample, the header starts at row 10.

31. You can see the following screen which contains the tabs of the Grainger Export file.

32. Select the Export Template from the drop-down list.

33. You will get the following message now as the tabs get mapped.

34. All the tabs whose names matched between the export file and the template file will automatically get mapped. We can also edit the mapping.

NOTE | It is not mandatory to map every tab and you can leave them as unmapped as well.

35. Once you have filled everything, click on Export.

36. You will get the following message.

37. Now, when you go to the Catalog Exports page, you will find your export at the top of the list. On the right-hand side, you can find a Product Load Summary as shown below. When you click on the   icon, the file will get downloaded into your system.