Amazon Business Integrated Catalogs

BuyerQuest import processes can be used to load in Amazon Business products to create a local catalog for users to shop from.

See Documentation Topics:

Catalog Uploads in Global Catalogs

Amazon Business Product Catalog

A fully searchable local catalog of Amazon Business products enables quick and easy product selection and ordering. Amazon Products are searched along with all the other products made available from Supplier Catalog uploads. 

After successful import of the Amazon Business product information, users may search and select products from Amazon Business to be shown product details and dynamic current pricing. 

The Amazon Business Product Catalog, once loaded, features dynamic pricing directly from the Amazon site. However, pricing is also stored locally as a back up.
BuyerQuest recommends that organizations shopping from their Amazon Business Integrated Catalog refresh and reload this Catalog once a week so that locally stored product pricing is as up to date as possible. 

Amazon Business Local Catalog Creation

The process for creating the local Amazon Business catalog uses the functionality in the Admin Control Panel at DATA LOADS > Manage File-Based Integrations > Import to import a set of Amazon product identifiers similar to Skus, known as ASINs.

Importing a set of ASINs for the Amazon Business products selected by the buying organization generates a Common Fields Catalog file that can be imported into BuyerQuest.

Generate the Common Fields Catalog File for Amazon Business Products

Importing a file of ASINs, the unique Amazon Business product identifiers, generates the Common Fields Catalog file for the selected Amazon Business products. It creates a file that is a FULL Common Fields Catalog file that can be processed to create Amazon Business product records that are searched and displayed in BuyerQuest. 

When UNSPSC codes are needed in the procurement workflow, they should be included in the ASIN file.

Click on Add Import above the Import Grid to open the Import specification.

1. Specify a Name for the Import.
2. Provide an optional Description.
3. Select the Entity Type Amazon Business Common Catalog Generator.
4. Specify the S3 location where the system will place the generated Common Fields Catalog file for automatic processing and upload. 
5. The Behavior is Full. The records from the import replace any existing Amazon Business product records in BuyerQuest. 
6. Set the Status to Enabled to run the Import.
7. Choose a Data File that comprises the  list of ASINs for the selected products. Include UNSPSC codes in the file if they are needed in the procurement workflow.
8. Specify the email addresses of the Recipients of Notifications for Success and Error.
9. Retain the settings for the Email Templates for Success and Error. 
10. Save and Process or Save. 

Validation Note:

When an ASIN is not found in the Amazon system, the row in the Import file is skipped. 

Sample ASIN Import File

This sample file includes the ASINs and their UNSPSC codes. 

ASIN_UNSPSC_10.9.csv

Amazon Business Attribute File Generation

After the Common Fields Catalog File has been successfully uploaded, additional Attributes may be retrieved from Amazon to be associated with the uploaded products. 

The Attribute import uses the same set of ASINs as is used in the Amazon Business Common Catalog Generator and results in a Full import. 

Attribute values retrieved include:

Image, Brand, color, EAN, Formats, Height Image, ISBN, Model, Size, UnitCount, Warranty, Weight, and Width. 

The import is available in the Admin Control Panel at DATA LOADS > Manage File-Based Integrations> Import.

1. Specify a Name for the Import.
2. Provide an optional Description.
3. Select the Entity Type Amazon Business Attribute Catalog Generator.
4. Specify the S3 location where the system will place the generated Attribute Catalog file for automatic processing and upload. 
5. The Behavior is Full.
6. Set the Status to Enabled to run the Import.
7. Choose a Data File that comprises the  list of ASINs for the selected products.
8. Specify the email addresses of the Recipients of Notifications for Success and Error.
9. Retain the settings for the Email Templates for Success and Error.
10. Save and Process or Save. 

Amazon Business Common Fields Catalog Upload

The Common Fields Catalog file generated by the import may be processed in either of two ways: 

Automatic: Processed from the S3 location specified in the Import. All Automatic uploads are Full, and will replace any existing Amazon Business product records in the BuyerQuest system.
Manual: Upload through the Global Catalog functionality in the BuyerQuest Main Menu at MY DOCUMENTS > Catalogs > Global Catalogs.
Manual uploads may be Delta, to add new products or update attribute values for existing products. 

See Documentation Topic Catalog Uploads in Global Catalogs. 

Sample Amazon Business Common Fields File for Upload

ABCommonFieldsFile10.10.csv