Difference between revisions of "Amazon Integration"

From Opentaps Wiki
Jump to navigationJump to search
m
(→‎UPC Codes)
Line 326: Line 326:
  
 
=UPC Codes=
 
=UPC Codes=
 +
 +
Amazon.com is divided into 'stores', each of which are responsible for certain types of products. Some stores (Health, Beauty) require a valid, unique UPC-A (12-digit) code to be supplied for each product. Depending on your requirements, the Amazon.com integration component can be configured to check UPC validity and supply a UPC to Amazon, and also can be configured to use the product's UPC as the SKU for Amazon. The relevant properties are these:
 +
 +
* opentaps.amazon.export.product.requireUpcCodes - set to 'true' to require a valid SKU before posting a product to Amazon. Must be set to 'true' if the opentaps.amazon.export.product.useUPCAsSKU property (below) is true
 +
* opentaps.amazon.export.product.useUPCAsSKU - set to 'true' to use the product's UPC as its Amazon SKU. Set to false to use either productId or a GoodIdentification of type 'SKU', depending on the value of the opentaps.amazon.export.product.useProductIdAsSKU property
 +
 +
Since Amazon only recognizes the 12-digit form of UPC (UPC-A), any 8-digit (compressed) UPC-E codes will be expanded to UPC-A codes before being posted to Amazon. If both a UPC-A code and a UPC-E code exist for a product, the UPC-A code will be used and the UPC-E code will be ignored. In the case of multiple UPC-A or multiple UPC-E codes existing for a given product, the most recently modified code will be used.
  
 
=Import of existing Amazon Products=
 
=Import of existing Amazon Products=

Revision as of 20:14, 23 November 2007

Setting Up Amazon Integration

To enable integration with Amazon.com:

  • Uncomment the line for the Amazon.com component in hot-deploy/component-load.xml
  • Load the seed data in hot-deploy/amazon/data/AmazonSeedData.xml
  • Load the demo data in hot-deploy/amazon/data/AmazonDemoData.xml or use it as a guide to configure your own data
  • Configure the following properties in hot-deploy/amazon/config/amazon.properties (see below for descriptions of the properties):
    • opentaps.amazon.merchantIdentifier
    • opentaps.amazon.merchantName
    • opentaps.amazon.userName
    • opentaps.amazon.password
    • opentaps.amazon.error.email.fromAddress (optional)
    • opentaps.amazon.error.email.toAddress (optional)
  • If you plan to use Opentaps to schedule shipments with carriers, comment out the ShipmentRouteSegment eECA in hot-deploy/amazon/entitydef/eecas_amazon_orders.xml and uncomment the completePack sECA in hot-deploy/amazon/servicedef/secas_amazon_orders.xml. This will ensure that the tracking numbers returned by the carrier are correctly posted to Amazon.

Basic Workflow

  • Product Importing
    • The Amazon integration component disallows the changing of the ASIN and SKU GoodIdentification numbers in the catalog manager.
  • Customer Matching
    • Amazon uses email address as the unique identifier of a customer.
    • Amazon sends phone numbers which are parsed with regex into separate area code and phone numbers
    • Amazon sends state and country codes which are matched against the Geo and GeoAssoc entities in opentaps.
  • Order Importing
    • Pending order documents are downloaded from Amazon and stored periodically (opentaps.amazon.storePendingOrderDocuments service)
    • Acknowledgement is posted to Amazon of downloaded order documents (opentaps.amazon.acknowledgeOrderDocumentDownload service)
    • Amazon orders are extracted from stored order documents (opentaps.amazon.extractOrdersForImport service)
    • Extracted orders are imported into the Opentaps data model (opentaps.amazon.importOrders service)
    • Acknowledgement is posted to Amazon of imported orders (opentaps.amazon.acknowledgeImportedOrders service)
    • Acknowledgement is posted to Amazon of fulfilled (shipped) order items. This is accomplished by two independent services: opentaps.amazon.queueShippedItemsForFulfillmentPost, which is responsible for detecting shipment of order items related to Amazon orders (currently via an entity-ECA triggered by the update of a ShipmentRouteSegment.carrierServiceStatusId to SHRSCS_ACCEPTED) and queueing them for fulfillment acknowledgement; and opentaps.amazon.acknowledgeFulfilledOrderItems which posts the fulfillment acknowledgement to Amazon of any order items in the acknowledgement queue.
    • Posted acknowledgement documents are periodically checked for availability of their related processing report from Amazon. If the processing report becomes available it will be retrieved and the statuses of the related objects updated according to the information in the report.
    • There are no execution dependencies - these steps will all run independently from one another by scheduled jobs and will operate on whatever data is available in the right condition at each runtime.

Services

Service Area Action Notes
opentaps.amazon.

storePendingOrderDocuments

Orders Requests all pending order documents from Amazon and stores each document in the AmazonOrderDocument entity. The service will fail only if there is a database error or a communication error with Amazon. Each document is treated separately - if the download of one document fails, the AmazonOrderDocument record will reflect the error and reason, but other documents in the same batch won't be affected. If a document download fails, the service will keep trying to download it from Amazon at each run. Documents will also fail if they consist of invalid or unparseable XML.
  • An attempt to parse the XML of the downloaded document is made before storing a success result
opentaps.amazon.

acknowledgeOrderDocumentDownload

Orders Finds any AmazonOrderDocuments in the database which have been successfully downloaded, but for which download acknowledgement has not yet been posted back to Amazon, and posts that acknowledgement. The service will fail only in the case of a database error. If there is an error posting acknowledgement, each of the affected AmazonOrderDocuments will reflect the failure and the reason. The AmazonOrderDocument.ackStatusId field will be set to AMZN_DOC_ACKED or AMZN_DOC_ACK_ERR.
opentaps.amazon.

extractOrdersForImport

Orders Finds any AmazonOrderDocuments in the database which have been successfully downloaded *and* successfully acknowledged, and for which extraction has failed no more than the number of times defined in the opentaps.amazon.import.order.retry.threshold.extract property, and attempts to parse each document in order to extract information about Amazon orders. The service will fail only in the case of a database error. Order documents are dealt with in an atomic fashion - if a document is unparseable or there is a problem extracting or storing order information into the import tables for any order in an order document, the entire order document will be marked as a failure and no orders will be extracted from it. Records in these entities will be created for each Amazon order extracted successfully (see the Entities section below for a description of the contents of each entity):
  • AmazonOrder
  • AmazonOrderItem
  • AmazonOrderItemPriceComponent
  • AmazonOrderItemFee
  • AmazonOrderItemTaxJurisdtn
  • AmazonOrderItemTaxAmount
  • AmazonOrderItemTaxRate
  • AmazonOrderItemPromo
  • When dates for order date and order posted date are extracted from the XML as strings, they are corrected to the server's timezone before being stored in AmaonOrder as timestamps.
opentaps.amazon.

importOrders service

Orders Creates the constellation of order-related data from any unimported Amazon orders, or any Amazon orders for which import has failed no more than the number of times defined in the opentaps.amazon.import.order.retry.threshold.import property. Each order will succeed or fail independently of the others - the service will only return error in the case of a database error. Individual Amazon orders are updated to AMZN_ORDR_IMPTD status if successful, AMZN_ORDR_IMPTD_ERR if unsuccessful. If unsuccessful, the importFailure count for the Amazon order will be incremented and the reason for the failure will be recorded in the corresponding AmazonOrder.importErrorMessage field. If successful, an AmazonOrderImport record and one or more AmazonOrderItemImport records will be created to define the relation to the Opentaps order and items. An AmazonParty record will also be created if the customer didn't previously exist in the system (determined by looking for the buyerEmailAddress in the AmazonParty entity).
opentaps.amazon.

acknowledgeImportedOrders

Orders Finds any Amazon orders which have been successfully imported and haven't yet been acknowledged, or for which acknowledgement failed previously. Constructs one XML document and posts it to Amazon, and updates each order's status to AMZN_ORDR_ACK_SENT if the post is successful, and AMZN_ORDR_SC_ACK_ERR if unsuccessful. All orders succeed or fail together, and the AmazonOrder.acknowledgeErrorMessage field stores the reason for failure. If successful, the AmazonOrder.processingDocumentId and AmazonOrder.acknowledgeMessageId fields are updated with values used later by the opentaps.amazon.checkAcknowledgementStatuses to retrieve processing data.
opentaps.amazon.

queueShippedItemsForFulfillmentPost

Orders Triggered by confirming a shipment with a carrier. If the shipment contains items related to an Amazon order, constructs an AmazonOrderItemFulfillment record for each item, for the quantity shipped, with ackStatusId AMZN_SHIP_NOT_ACKED.
opentaps.amazon.

acknowledgeFulfilledOrderItems

Orders Finds any AmazonOrderItemFulfillment records which haven't yet been acknowledged, or for which acknowledgement failed previously. Constructs one XML document and posts it to Amazon, and updates each order item's ackStatusId to AMZN_SHIP_ACK_SENT if the post is successful, and AMZN_SHIP_ACK_ERR if unsuccessful. All order item fulfillments succeed or fail together, and the AmazonOrderItemFulfillment.acknowledgeErrorMessage field stores the reason for failure. If successful, the AmazonOrderItemFulfillment.processingDocumentId and AmazonOrderItemFulfillment.acknowledgeMessageId fields are updated with values used later by the opentaps.amazon.checkAcknowledgementStatuses to retrieve processing data.
opentaps.amazon.

checkAcknowledgementStatuses

Orders Finds any Amazon-related objects (currently AmazonOrder and AmazonOrderItemFulfillment) which are recorded as having had an acknowledgment posted to Amazon. Retrieves the set of processingDocumentIds from these objects, and retrieves each document. Each document is examined for reports of processing errors relating to the objects. The object's ackStatusId field is updated to a success status (AMZN_ORDER_SCSS_ACKED/AMZN_ORDR_FAIL_ACKED or AMZN_SHIP_ACKED) or error status (AMZN_ORDER_SCSS_ACK_ERR/AMZN_ORDR_FL_ACK_ERR or AMZN_SHIP_ACK_ERR) and the object's acknowledgeErrorMessage holds any errors reported.
opentaps.amazon.

cancelUnimportedOrder

Orders Posts failure acknowledgement to Amazon of an order which can't or won't be imported. AmazonOrder.statusId is set to AMZN_ORDR_CANCELLED and ackStatusId to AMZN_ORDR_ACK_FL_ST if success or AMZN_ORDR_FL_ACK_ERR if error.

Entities

Entity Holds
AmazonOrder
AmazonOrderDocument
AmazonOrderImport
AmazonOrderItem
AmazonOrderItemFee
AmazonOrderItemFulfillment
AmazonOrderItemImport
AmazonOrderItemPriceComp
AmazonOrderItemPromo
AmazonOrderItemTaxAmount
AmazonOrderItemTaxJurisdtn
AmazonOrderItemTaxRate
AmazonParty

Configuration Properties

Property Description Default Value

Credentials

merchantIdentifier Merchant Identifier credential specified by Amazon for the merchant
merchantName Merchant Name credential specified by Amazon for the merchant
password Password specified by Amazon for the merchant
url Production environment URL for Amazon SOAP services https://merchant-api.amazon.com/gateway/merchant-interface-mime
userName Username credential specified by Amazon for the merchant

Basic configuration properties

import.productStoreId ID of the ProductStore to use when importing orders AMAZON
export.product.price.productStoreGroupId productStoreGroupId for ProductPrice records in the Amazon channel -NA_
export.product.requireUpcCodes Require UPC codes for products posted to Amazon (UPC codes are required in at least the Health and Beauty stores) true
export.product.useProductIdAsSKU If false, a GoodIdentification of goodIdentificationTypeId SKU will be required in order to post a product to Amazon true

Error email configuration

error.email.errorEmailLocale Locale setting for error emails en_US
error.email.errorEmailScreenUri.orders Screen location for order error email template component://amazon/widget/orders/AmazonOrderScreens.xml#errorEmail
error.email.errorEmailScreenUri.productFeedProcessingAgeWarning Screen location for the template for the email warning of the age of the last successful product feed processing document download component://amazon/widget/products/AmazonProductScreens.xml#productFeedProcessingAgeWarning
error.email.fromAddress 'From' email address for all error emails
error.email.productFeedProcessingAgeWarning.thresholdHours Age threshold for warning of the last successful product feed processing document download (in hours) 24
error.email.sendErrorEmails Send emails when errors occur in order import or product export true
error.email.toAddress 'To' email address for all error emails

Miscellaneous properties

default.uom.length Amazon length unit of measure to use in cases where a unit of measure is missing for a product dimension IN
default.uom.weight Amazon weight unit of measure to use in cases where a unit of measure is missing for a product weight LB
createdByAmazonApplication Generic string for description fields of automatically-created records Created by application
export.product.conditionType Condition for exported products - must be one of:
  • New
  • UsedLikeNew
  • UsedVeryGood
  • UsedGood
  • UsedAcceptable
  • CollectibleLikeNew
  • CollectibleVeryGood
  • CollectibleGood
  • CollectibleAcceptable
  • Refurbished
  • Club
 New

Product image export

default.image.main Mapping of Opentaps Product field/productContentTypeId to Amazon Main product image LARGE_IMAGE_URL
default.image.pt1 Mapping of Opentaps Product field/productContentTypeId to Amazon alternate product image 1
default.image.pt2 Mapping of Opentaps Product field/productContentTypeId to Amazon alternate product image 2
default.image.pt3 Mapping of Opentaps Product field/productContentTypeId to Amazon alternate product image 3
default.image.pt4 Mapping of Opentaps Product field/productContentTypeId to Amazon alternate product image 4
default.image.pt5 Mapping of Opentaps Product field/productContentTypeId to Amazon alternate product image 5
default.image.pt6 Mapping of Opentaps Product field/productContentTypeId to Amazon alternate product image 6
default.image.pt7 Mapping of Opentaps Product field/productContentTypeId to Amazon alternate product image 7
default.image.pt8 Mapping of Opentaps Product field/productContentTypeId to Amazon alternate product image 8
default.image.search Mapping of Opentaps Product field/productContentTypeId to Amazon Search product image SMALL_IMAGE_URL
default.image.swatch Mapping of Opentaps Product field/productContentTypeId to Amazon Swatch product image

Product inventory export

export.inventory.inventoryIsAvailableIfMinimumStock Post product inventory as Available if a product's ProductFacility.minimumStock > 0 true
export.inventory.postActualInventory Post ATP for a product to Amazon. If false, a simple Available boolean will be posted true
export.inventory.postInventoryDaysToShip Post ProductFacility.daysToShip for a product to Amazon true

Order import

import.approveOrders Automatically approve orders imported from Amazon true
import.decimalPrecision Number of places of decimal precision to use for intermediate price calculations during order import 2
import.decimalRounding Rounding mode to use for intermediate price calculations during order import ROUND_HALF_UP
import.maxDaysToShip.Expedited Number of days to add to the current date in order to calculate a Ship-By Date for orders with Expedited service level 3
import.maxDaysToShip.Standard Number of days to add to the current date in order to calculate a Ship-By Date for orders with Standard service level 7
import.requireInventory Setting for the Require Inventory flag of order item inventory reservations during order import true
import.requireTaxAuthority Require an Amazon taxLocationCode to Opentaps taxAuthorityGeoId/taxAuthorityPartyId mapping in the AmazonTaxLocToTaxAuth entity to successfully import orders with tax amounts true

Retry thresholds

export.product.retry.threshold.post Number of times to retry posting new/updated products 3
import.order.retry.threshold.acknowledge Number of times to retry acknowledging an order before giving up (not implemented yet) 3
import.order.retry.threshold.import Number of times to retry importing an order before giving up 3
import.document.retry.threshold.acknowledge Number of times to acknowledging a pending order download before giving up (not implemented yet) 3
import.document.retry.threshold.download Number of times to retry a failed pending order document download before giving up (not implemented yet) 3
import.document.retry.threshold.extract Number of times to retry extracting orders from a pending order download before giving up 3

Phone number parsing

import.phone.regexp Regular expression used for identifying and parsing phone numbers during order import. Note that backslashes must be doubled. [0]|[2-9]){1})\\D*(\\d{3}\\D*\\d{4})\\D*(\\d*)\\s*$
import.phone.regexp.group.areaCode Index of the regular expression capturing group defined in the import.phone.regexp property which represents the area code. Note that capturing groups begin at 1. 2
import.phone.regexp.group.countryCode Index of the regular expression capturing group defined in the import.phone.regexp property which represents the country code. Note that capturing groups begin at 1. 1
import.phone.regexp.group.extension Index of the regular expression capturing group defined in the import.phone.regexp property which represents the extension. Note that capturing groups begin at 1. 4
import.phone.regexp.group.phoneNumber Index of the regular expression capturing group defined in the import.phone.regexp property which represents the phone number itself. Note that capturing groups begin at 1. 3

Shipping configuration

shipping.carrierPartyId.fedEx Opentaps partyId of the carrier party for Federal Express FEDEX
shipping.carrierPartyId.ups Opentaps partyId of the carrier party for UPS UPS
shipping.carrierPartyId.usps Opentaps partyId of the carrier party for the US Postal Service USPS
import.shipmentMethodTypeId.Expedited Shipment method to use for orders with Expedited service level AIR
import.shipmentMethodTypeId.Standard Shipment method to use for orders with Standard service level GROUND
import.carrierPartyId.Expedited PartyId of the carrier party which handles Expedited shipments UPS
import.carrierPartyId.Standard PartyId of the carrier party which handles Standard shipments UPS

Test Cases

Order Item Fulfillment (Charge-When-Ship)

Test Case Action Result
1 Order an item on Amazon.com and wait until the order has been imported into Opentaps. Pack the full order in the Warehouse application. Wait until the scheduled job for the opentaps.amazon.acknowledgeFulfilledOrderItems services has run (or run it manually). Result: There should be AmazonOrderItemFulfillment records representing the fulfilled order items, for which the ackStatusId field should be AMZN_SHIP_ACK_ERR. The orders should be marked 'Confirmed' in the Amazon Seller Central site's 'Manage Orders' screen.
2 Place a multiple-item order on Amazon.com and wait until the order has been imported. Pack part of the order. Wait until the service has run as above. The shipped order items should be noted in Seller Central, but the entire order should not be marked confirmed since it hasn't all been shipped.
3 Pack the rest of the order from case 2. Wait until the service has run as above. The order should be marked confirmed in Seller Central, since it has been fully shipped.

UPC Codes

Amazon.com is divided into 'stores', each of which are responsible for certain types of products. Some stores (Health, Beauty) require a valid, unique UPC-A (12-digit) code to be supplied for each product. Depending on your requirements, the Amazon.com integration component can be configured to check UPC validity and supply a UPC to Amazon, and also can be configured to use the product's UPC as the SKU for Amazon. The relevant properties are these:

  • opentaps.amazon.export.product.requireUpcCodes - set to 'true' to require a valid SKU before posting a product to Amazon. Must be set to 'true' if the opentaps.amazon.export.product.useUPCAsSKU property (below) is true
  • opentaps.amazon.export.product.useUPCAsSKU - set to 'true' to use the product's UPC as its Amazon SKU. Set to false to use either productId or a GoodIdentification of type 'SKU', depending on the value of the opentaps.amazon.export.product.useProductIdAsSKU property

Since Amazon only recognizes the 12-digit form of UPC (UPC-A), any 8-digit (compressed) UPC-E codes will be expanded to UPC-A codes before being posted to Amazon. If both a UPC-A code and a UPC-E code exist for a product, the UPC-A code will be used and the UPC-E code will be ignored. In the case of multiple UPC-A or multiple UPC-E codes existing for a given product, the most recently modified code will be used.

Import of existing Amazon Products

Data Model

  • AmazonProduct holds Amazon-specific data and data relating to product posting times, successes and failures
  • AmazonProductPrice, AmazonProductImage and AmazonProductInventory hold only data relating to product posting times, successes and failures and are each related to AmazonProduct
  • ProductPrice holds Amazon-specific prices, designated by ProductPrice.productStoreGroupId
  • AmazonProductSearchTerms and AmazonProductBulletPoint hold search terms and bullet points and are related to AmazonProduct by the productId field
  • The AmazonProductUsedFor entity holds possible UsedFor values, and AmazonUsedForValue relates the AmazonProduct and AmazonProductUsedFor entities by the productId field
  • The AmazonProductTargetAudience entity holds possible TargetAudience values, and AmazonTargetAudienceValue relates the AmazonProduct and AmazonProductTargetAudience entities by the productId field
  • The AmazonProductOtherItemAttr entity holds possible OtherItemAttribute values, and AmazonOtherItemAttrValue relates the AmazonProduct and AmazonProductOtherItemAttr entities by the productId field
  • AmazonProductItemType holds possible ItemType values and is related directly to AmazonProduct by the AmazonProduct.itemTypeId field

Notes

  • Amazon product import must happen after Opentaps products have been imported
  • Products must have matching SKU GoodIdentification records
  • Products must have matching UPCA GoodIdentification records if the opentaps.amazon.export.product.requireUpcCodes property is set to true (this is required for the Health store)
  • Required records:
    • AmazonProduct (1)
    • ProductPrice (1 or 2)
    • AmazonProductPrice (1)
    • AmazonProductInventory (1)
    • AmazonProductImage (1)
  • Optional records:
    • AmazonProductSearchTerms (1 for each Amazon search term, minimum 0, maximum 5)
    • AmazonProductBulletPoint (1 for each Amazon bullet point, minimum 0, maximum 5)
    • AmazonUsedForValue (1 for each Amazon UsedFor value, minimum 0, maximum 5)
    • AmazonTargetAudienceValue (1 for each Amazon TargetAudience value, minimum 0, maximum 3)
    • AmazonOtherItemAttrValue (1 for each Amazon OtherItemAttributes value, minimum 0, maximum 5)


Records to Create

AmazonProduct

Field Type Allow Empty Initial Value Notes
productId String No Opentaps productId
statusId String No AMZN_PROD_CHANGED
productTaxCode String No From imported data
releaseDate Date Yes From imported data
itemTypeId String Yes From imported data Must exist in AmazonProductItemType entity
nodeId String Yes null or from imported data Must exist in AmazonProductBrowseNode entity
priority Integer Yes From imported data Not currently implemented
browseExclusion String (Y/N) Yes From imported data Not currently implemented
recommendationExclusion String (Y/N) Yes From imported data Not currently implemented
cost Currency Yes From imported data Not currently implemented
currencyUom String Yes From imported data Not currently implemented
tier Integer Yes From imported data Not currently implemented
purchasingCategory String Yes From imported data Not currently implemented
purchasingSubCategory String Yes From imported data Not currently implemented
packagingType String Yes From imported data Not currently implemented
underlyingAvailability String Yes From imported data Not currently implemented
replenishmentCategory String Yes From imported data Not currently implemented
dropShipStatus String Yes From imported data Not currently implemented
outOfStockWebsiteMessage String Yes From imported data Not currently implemented
registeredParameter String Yes From imported data Not currently implemented
processingDocumentId Integer Yes null
postTimestamp Date Yes null
postErrorMessage String Yes null
postFailures Integer No 0
ackStatusId String No AMZN_PROD_NOT_ACKED
acknowledgeTimestamp Date Yes null
acknowledgeErrorMessage String Yes null
acknowledgeMessageId String Yes null

ProductPrice

Field Type Allow Empty Initial Value Notes
productId String No Opentaps productId
productPriceTypeId String No DEFAULT_PRICE or LIST_PRICE Value depends on whether the price is a standard price or a sale price. Use LIST_PRICE for standard prices and DEFAULT_PRICE for sale prices
productPricePurposeId String No PURCHASE
currencyUomId String No Value of ProductStore.defaultCurrencyUomId for the productStoreId defined in the opentaps.amazon.import.productStoreId property
productStoreGroupId String No Value of the opentaps.amazon.export.product.price.productStoreGroupId property
fromDate Date No Current date
thruDate Date Yes If the price is a standard price, use the current date if the product is not active on Amazon.com, use null if the product is currently active. If the price is a sale price, use null unless the sale price has expired, in which case use the current date or the date of the expiry.
price Currency No Price of the product in the Amazon channel, corrected for the currency in the currencyUomId field

AmazonProductPrice

Field Type Allow Empty Initial Value Notes
productId String No Opentaps productId Must exist in AmazonProduct
statusId String No AMZN_PROD_CHANGED
processingDocumentId Integer Yes null
postTimestamp Date Yes null
postErrorMessage String Yes null
postFailures Integer No 0
ackStatusId String No AMZN_PROD_NOT_ACKED
acknowledgeTimestamp Date Yes null
acknowledgeErrorMessage String Yes null
acknowledgeMessageId Integer Yes null

AmazonProductInventory

Field Type Allow Empty Initial Value Notes
productId String No Opentaps productId Must exist in AmazonProduct
statusId String No AMZN_PROD_CHANGED
processingDocumentId Integer Yes null
postTimestamp Date Yes null
postErrorMessage String Yes null
postFailures Integer No 0
ackStatusId String No AMZN_PROD_NOT_ACKED
acknowledgeTimestamp Date Yes null
acknowledgeErrorMessage String Yes null
acknowledgeMessageId Integer Yes null

AmazonProductImage

Field Type Allow Empty Initial Value Notes
productId String No Opentaps productId Must exist in AmazonProduct
statusId String No AMZN_PROD_CHANGED
processingDocumentId Integer Yes null
postTimestamp Date Yes null
postErrorMessage String Yes null
postFailures Integer No 0

AmazonProductSearchTerms

Field Type Allow Empty Initial Value Notes
searchTermId String No Auto-sequenced
productId String No Opentaps productId Must exist in AmazonProduct
description Integer No From imported data

AmazonProductBulletPoint

Field Type Allow Empty Initial Value Notes
bulletPointId String No Auto-sequenced
productId String No Opentaps productId Must exist in AmazonProduct
description Integer No From imported data

AmazonUsedForValue

Field Type Allow Empty Initial Value Notes
productId String No Opentaps productId Must exist in AmazonProduct
usedForId String No From imported data Must exist in AmazonProductUsedFor

AmazonTargetAudienceValue

Field Type Allow Empty Initial Value Notes
productId String No Opentaps productId Must exist in AmazonProduct
targetAudienceId String No From imported data Must exist in AmazonProductTargetAudience

AmazonOtherItemAttrValue

Field Type Allow Empty Initial Value Notes
productId String No Opentaps productId Must exist in AmazonProduct
otherItemAttrId String No From imported data Must exist in AmazonProductOtherItemAttr
Retrieved from "https://docs.opentaps.org/docs/index.php?title=Amazon_Integration&oldid=1625"