Using PCC Amazon Connector

Amazon is a leading e-commerce platform and businesses can set up an online store and sell their products through it. You will be able to download the export file in the format required by Amazon from PCC which you can feed into Amazon.

Click the View Detailsicon to view the details and features of the connector and the following is displayed.

Figure 221: Amazon connector description

Downloading the Template from Amazon

The first step in configuring the Amazon connector is to download the Amazon template for your business. In this section, let us see how we can download the same using the Amazon seller account.

1. Go to the Amazon Seller account website and click on Seller Central Login.

2. Now, you will have to sign into your account by filling the credentials.

3. Once you login, click on the    icon on the top-left and a drop-down list appears.

4. Select Inventory from the drop-down list on the left-hand side and select Add Products via Upload

5. On the new window that opens, click on Download an Inventory File tab.

6. Now, select the types of products you want to sell. You can choose multiple products at the same time as well. In this example, let us select ‘Built-in Dishwashers’.

7. You can find the summary of your products at the bottom of the list of products.

8. Now, you must select the applicable Marketplace(s)

9. Now, you must click on Generate Template.

10. The Amazon template will get downloaded into your system.

Here is a sample of the template:

Configuring the Connector

You need to configure the connector before you can download the export document in the format required by Amazon.  

To add a new Amazon store configuration:

1. Go to the PCC Platform Connectors screen and click the Set Configurations    icon available for Amazon as shown below.

The following screen appears.

Figure 221: PCC Amazon Connector screen

By default, the Setup Credentials tab is selected.

2. Click Add New Store Configuration and the following dialog box appears to add the store details.

Enter Template Name.

3. For uploading the Amazon Template File, click on the Browse button and the following box opens where you can browse to the location where you have stored the file. Select the file and click on Open.

4. Now click on the Upload button and you will get the following message.

5. Once the file is uploaded, you will have to click Next on the bottom of the screen. In case you want to delete the file and update with a new file, click on Remove File and follow the previous steps to reupload the required file.

As the window opens moves to Template Mapping tab, you must select the Catalog from the drop-down list.

Now, you must set up the attribute mapping between Amazon on the left-hand side and PCC catalog on the right-hand side.

You must note that the data from the Amazon template will be bifurcated among various tabs. So, you must map each of the tabs.

6. Once you complete mapping all the entities, click on Save Template.

You will get the below screen as the attributes get mapped.

You will get the below screenshot if the mapping has been successful. If not, you will have to recheck if you have mapped the attributes correctly.

Now, you can see that the newly added Amazon template “John Amazon Test” is visible on the PCC Amazon Connector page.

7. If you want to edit the Amazon template, you must click on the  icon on the left-hand side of the template.

8. The below window will open where you can make the edits to the Template Name and/or the Browse Path and click Next.

9. Now as the Template Mapping tab opens, you can make edits to the mapping and click on Save Template and the changes will be reflected on the template.

10. You can delete the uploaded Amazon Template by clicking on the icon on the left-hand side of the template.

11. Now the following window will open asking you if you are sure that you want to delete this template. Once you click on Delete Template, the template will be deleted.

You can also download the Amazon Template by clicking on the icon on the left-hand side of the template.

From the main drop-down list, click on Catalog Exports.

1. On the new window that opens, click on +New Export.

2. On the new window that opens, select the catalog from the drop-down list.

Once you select the catalog, the following window opens giving you the option to choose the required export type. Since we are looking for the Amazon Template export, click on Export found inside the Amazon Template Export.

Now, as the following dialog box opens, you must fill in the details one-by-one.

3. You must Enter Export Name.

You have 3 Export Options to choose from. They are explained as follows:

• All - By default, this option will be selected. When you choose this option, All the SKU(s) will be exported.

• SKUs in selected nodes - When you choose this option, you can select the node(s) which you want to export.

• SKUs using saved condition - When you choose this option, you can select a Saved Condition. As you start typing, PCC will start suggesting the various conditions that have been saved.

4. You can select Incremental Export Only if you only want SKU(s) added/updated after the selected date to be exported.

Once you select Incremental Export Only, you will have the following 3 options to choose from:

• SKUs modified since last export

• SKUs modified since last export by me (The specific individual account)

• SKUs modified since date – When you select this option, you must click on the    icon and choose the date from which you want the SKUs that have got modified

5. Now, you must select the Export Template which you previously uploaded from the drop-down list.  

6. Once all the details are filled, the Export button will be activated, and you must click on it to proceed.

You will get the following message.

Once you open the Catalog Exports page, you will find that our export is ready. If the file is error-free, the status will show as COMPLETE but if the file has an error, the status will show as ERROR – in which case, you will have to revisit the previous steps and recheck if you had made any mistake.

7. You can download the file by clicking on the icon on the right-hand side of the window and the file will be downloaded to your system in the xlsm format.

8. You must log into the Amazon Seller account again to upload the file. Once you login, click on the  icon on the top-left and a drop-down list appears.

9. Select Inventory from the drop-down list on the left-hand side and select Add Products via Upload

10. Select the Upload your Inventory File tab. You can either drag and drop the file or browse and select the file from your system and select Upload File.

11. Once you drop or select the file, the ‘Upload file’ icon will get activated. Click on Upload File.

12. You can monitor the Upload status by selecting the Monitor Upload Status tab.

13. Click on the icon again and select Inventory from the drop-down list and choose Manage Inventory.

You will be able to find the products which you uploaded along with the other details as shown in the sample below.