Connect Amazon Seller Central to Azure SQL in minutes

Directly connect Amazon Seller Central to Azure SQL in an easy-to-use format.

Integrate Amazon Seller Central data to Azure SQL

amazon seller central azure sql connector

Stream your marketing data from Amazon Seller Central to Azure SQL

About Amazon Seller Central

Easily Connect Your Salesforce Data

About Azure SQL

Connect all your data to Microsoft Azure SQL

Connect Amazon MWS (Seller Central) to Azure SQL in 2023

Do you plan to connect and visualize your Amazon Seller Central in MS Azure SQL?

It is very simple to connect Amazon Seller Central to Azure SQL, it can be done in a fast and easy manner with Windsor.ai.

 

First Step

You need to select Amazon Seller Central as a Data Source and Grant Access to Windsor.ai.

Salesforce Windsor.ai Onboarding Screen

 

 

Second step

In Select Destination select AzureSQL as destination

azure sql destinations

 

Third  step

Enter all the credentials required and click Save

azure sql task

Fifth step

Your data will now be streamed Amazon Seller Central data to Azure SQL. In case there is an error you will be notified.

Amazon Seller Central metrics & dimensions available for streaming into Azure SQL

Connect your data

 

nametypedescription
Account IDTEXTThe account ID
Account NameTEXTThe account name
amazon-order-id (get_amazon_fulfilled_shipments_data_general)TEXTamazon-order-id (get_amazon_fulfilled_shipments_data_general) Amazon's; unique, displayable identifier for an order.;
amazon-order-item-id (get_amazon_fulfilled_shipments_data_general)TEXTamazon-order-item-id (get_amazon_fulfilled_shipments_data_general); Amazon's unique, displayable identifier for an item within the order.;
bill-address-1 (get_amazon_fulfilled_shipments_data_general)TEXTbill-address-1 (get_amazon_fulfilled_shipments_data_general) The first; line of a standard address.;
bill-address-2 (get_amazon_fulfilled_shipments_data_general)TEXTbill-address-2 (get_amazon_fulfilled_shipments_data_general) The; second line of a standard address.;
bill-address-3 (get_amazon_fulfilled_shipments_data_general)TEXTbill-address-3 (get_amazon_fulfilled_shipments_data_general) The third; line of a standard address.;
bill-city (get_amazon_fulfilled_shipments_data_general)CITYbill-city (get_amazon_fulfilled_shipments_data_general) The city of a; standard address.;
bill-country (get_amazon_fulfilled_shipments_data_general)COUNTRYbill-country (get_amazon_fulfilled_shipments_data_general) ISO 3166; standard two-letter country code.;
bill-postal-code (get_amazon_fulfilled_shipments_data_general)TEXTbill-postal-code (get_amazon_fulfilled_shipments_data_general) The; postal (zip) code of a standard address.;
bill-state (get_amazon_fulfilled_shipments_data_general)TEXTbill-state (get_amazon_fulfilled_shipments_data_general) The state or; region of a standard address.;
buyer-email (get_amazon_fulfilled_shipments_data_general)TEXTbuyer-email (get_amazon_fulfilled_shipments_data_general) The; encrypted email address of the buyer.;
buyer-name (get_amazon_fulfilled_shipments_data_general)TEXTbuyer-name (get_amazon_fulfilled_shipments_data_general) The full name; of the buyer.;
buyer-phone-number (get_amazon_fulfilled_shipments_data_general)TEXTbuyer-phone-number (get_amazon_fulfilled_shipments_data_general) The; phone number of the buyer.;
carrier (get_amazon_fulfilled_shipments_data_general)TEXTcarrier (get_amazon_fulfilled_shipments_data_general) The name of the; carrier the package was shipped with.;
currency (get_amazon_fulfilled_shipments_data_general)TEXTcurrency (get_amazon_fulfilled_shipments_data_general) The currency; used for the purchase. Supported currencies include USD, CAD, GBP,; EUR, and JPY.;
estimated-arrival-date (get_amazon_fulfilled_shipments_data_general)DATEestimated-arrival-date (get_amazon_fulfilled_shipments_data_general); The estimated date of delivery to the customer.;
fulfillment-center-id (get_amazon_fulfilled_shipments_data_general)TEXTfulfillment-center-id (get_amazon_fulfilled_shipments_data_general); The unique identifier from which fulfillment center the order was; shipped.;
fulfillment-channel (get_amazon_fulfilled_shipments_data_general)TEXTfulfillment-channel (get_amazon_fulfilled_shipments_data_general); Indicates how the order was fulfilled, via Amazon (AFN) or Merchant; (MFN);
gift-wrap-price (get_amazon_fulfilled_shipments_data_general)NUMERICgift-wrap-price (get_amazon_fulfilled_shipments_data_general) The; amount that the buyer paid for gift wrap. Amount is aggregate of the; quantity, not unit price.;
gift-wrap-tax (get_amazon_fulfilled_shipments_data_general)NUMERICgift-wrap-tax (get_amazon_fulfilled_shipments_data_general) The amount; that the buyer paid for gift wrap tax. Amount is aggregate of the; quantity, not unit price.;
item-price (get_amazon_fulfilled_shipments_data_general)NUMERICitem-price (get_amazon_fulfilled_shipments_data_general) The amount; that the buyer paid for the item. Amount is aggregate of the quantity,; not unit price.;
item-promotion-discount (get_amazon_fulfilled_shipments_data_general)NUMERICitem-promotion-discount (get_amazon_fulfilled_shipments_data_general); Promotion discount applied to the order item.;
item-tax (get_amazon_fulfilled_shipments_data_general)NUMERICitem-tax (get_amazon_fulfilled_shipments_data_general) The amount that; the buyer paid for item tax. Amount is aggregate of the quantity, not; unit price.;
merchant-order-id (get_amazon_fulfilled_shipments_data_general)TEXTmerchant-order-id (get_amazon_fulfilled_shipments_data_general) A; unique identifier optionally supplied for the order by the Merchant.;
merchant-order-item-id (get_amazon_fulfilled_shipments_data_general)TEXTmerchant-order-item-id (get_amazon_fulfilled_shipments_data_general) A; unique identifier for an item within the order.;
payments-date (get_amazon_fulfilled_shipments_data_general)DATEpayments-date (get_amazon_fulfilled_shipments_data_general) The date; the buyer's credit card was charged and order processing was; completed.;
product-name (get_amazon_fulfilled_shipments_data_general)TEXTproduct-name (get_amazon_fulfilled_shipments_data_general) The short; title for the product, displayed in bold on the detail web page and in; the title bar of the browser window.;
purchase-date (get_amazon_fulfilled_shipments_data_general)DATEpurchase-date (get_amazon_fulfilled_shipments_data_general) The date; the order was placed.;
quantity-shipped (get_amazon_fulfilled_shipments_data_general)NUMERICquantity-shipped (get_amazon_fulfilled_shipments_data_general) The; number of this item that were shipped.;
recipient-name (get_amazon_fulfilled_shipments_data_general)TEXTrecipient-name (get_amazon_fulfilled_shipments_data_general) Name; field of a standard address.;
reporting-date (get_amazon_fulfilled_shipments_data_general)DATEreporting-date (get_amazon_fulfilled_shipments_data_general) The date; the data for this report became available in the FBA data store.;
sales-channel (get_amazon_fulfilled_shipments_data_general)TEXTsales-channel (get_amazon_fulfilled_shipments_data_general) The source; of the order.;
ship-address-1 (get_amazon_fulfilled_shipments_data_general)TEXTship-address-1 (get_amazon_fulfilled_shipments_data_general) The first; line of a standard address.;
ship-address-2 (get_amazon_fulfilled_shipments_data_general)TEXTship-address-2 (get_amazon_fulfilled_shipments_data_general) The; second line of a standard address.;
ship-address-3 (get_amazon_fulfilled_shipments_data_general)TEXTship-address-3 (get_amazon_fulfilled_shipments_data_general) The third; line of a standard address.;
ship-city (get_amazon_fulfilled_shipments_data_general)CITYship-city (get_amazon_fulfilled_shipments_data_general) The city of a; standard address.;
ship-country (get_amazon_fulfilled_shipments_data_general)COUNTRYship-country (get_amazon_fulfilled_shipments_data_general) ISO 3166; standard two-letter country code.;
ship-phone-number (get_amazon_fulfilled_shipments_data_general)TEXTship-phone-number (get_amazon_fulfilled_shipments_data_general) The; phone number associated with the ship-to address.;
ship-postal-code (get_amazon_fulfilled_shipments_data_general)TEXTship-postal-code (get_amazon_fulfilled_shipments_data_general) The; postal (ZIP) code of a standard address.;
ship-promotion-discount (get_amazon_fulfilled_shipments_data_general)NUMERICship-promotion-discount (get_amazon_fulfilled_shipments_data_general); Promotion discount applied to shipping.;
ship-service-level (get_amazon_fulfilled_shipments_data_general)TEXTship-service-level (get_amazon_fulfilled_shipments_data_general) An; enumerated value that determines the type of fulfillment service that; the buyer expects the merchant to use (e.g., Standard v. Expedited);
ship-state (get_amazon_fulfilled_shipments_data_general)TEXTship-state (get_amazon_fulfilled_shipments_data_general) The state or; region of a standard address.;
shipment-date (get_amazon_fulfilled_shipments_data_general)DATEshipment-date (get_amazon_fulfilled_shipments_data_general) The date; the shipment was completed (shipped) by the fulfillment center;
shipment-id (get_amazon_fulfilled_shipments_data_general)TEXTshipment-id (get_amazon_fulfilled_shipments_data_general) Encrypted; Amazon shipment id;
shipment-item-id (get_amazon_fulfilled_shipments_data_general)TEXTshipment-item-id (get_amazon_fulfilled_shipments_data_general); Encrypted Amazon shipment item id;
shipping-price (get_amazon_fulfilled_shipments_data_general)NUMERICshipping-price (get_amazon_fulfilled_shipments_data_general) The; amount that the buyer paid for shipping. Amount is aggregate of the; quantity, not unit price.;
shipping-tax (get_amazon_fulfilled_shipments_data_general)NUMERICshipping-tax (get_amazon_fulfilled_shipments_data_general) The amount; that the buyer paid for shipping tax. Amount is aggregate of the; quantity, not unit price.;
sku (get_amazon_fulfilled_shipments_data_general)TEXTsku (get_amazon_fulfilled_shipments_data_general) A merchant-defined; unique identifier for a product.;
tracking-number (get_amazon_fulfilled_shipments_data_general)TEXTtracking-number (get_amazon_fulfilled_shipments_data_general) The; carrier's tracking number for the package.;
Data SourceTEXTThe name of the Windsor connector returning the row
DateDATEDate to which metrics apply
Day of monthTEXTDay of the month
asin (get_fba_estimated_fba_fees_txt_data)TEXTasin (get_fba_estimated_fba_fees_txt_data) Amazon Standard; Identification Numbers (ASINs) are unique blocks of 10 letters or; numbers that identify products. ASINs are assigned by Amazon. You can; find the ASIN on the product detail page.;
brand (get_fba_estimated_fba_fees_txt_data)TEXTbrand (get_fba_estimated_fba_fees_txt_data) The brand of your product;
currency (get_fba_estimated_fba_fees_txt_data)TEXTcurrency (get_fba_estimated_fba_fees_txt_data) The currency in which; the fee is calculated;
estimated-fee-total (get_fba_estimated_fba_fees_txt_data)NUMERICestimated-fee-total (get_fba_estimated_fba_fees_txt_data) The; estimated fulfillment and selling on Amazon fee;
estimated-order-handling-fee-per-order (get_fba_estimated_fba_fees_txt_data)NUMERICestimated-order-handling-fee-per-order; (get_fba_estimated_fba_fees_txt_data) The estimated order handling fee; per order;
estimated-pick-pack-fee-per-unit (get_fba_estimated_fba_fees_txt_data)TEXTestimated-pick-pack-fee-per-unit (get_fba_estimated_fba_fees_txt_data);
estimated-referral-fee-per-unit (get_fba_estimated_fba_fees_txt_data)NUMERICestimated-referral-fee-per-unit (get_fba_estimated_fba_fees_txt_data); The estimated selling on Amazon referral fee;
estimated-variable-closing-fee (get_fba_estimated_fba_fees_txt_data)NUMERICestimated-variable-closing-fee (get_fba_estimated_fba_fees_txt_data); The estimated variable closing fee for your product;
estimated-weight-handling-fee-per-unit (get_fba_estimated_fba_fees_txt_data)NUMERICestimated-weight-handling-fee-per-unit; (get_fba_estimated_fba_fees_txt_data) The estimated weight handling; fee for your product based on the outbound shipping weight;
expected-fulfillment-fee-per-unit (get_fba_estimated_fba_fees_txt_data)NUMERICexpected-fulfillment-fee-per-unit; (get_fba_estimated_fba_fees_txt_data);
fnsku (get_fba_estimated_fba_fees_txt_data)TEXTfnsku (get_fba_estimated_fba_fees_txt_data) Unique identifier assigned; by Amazon to products stored in and fulfilled from an Amazon; fulfillment center;
fulfilled-by (get_fba_estimated_fba_fees_txt_data)TEXTfulfilled-by (get_fba_estimated_fba_fees_txt_data) The entity that; fulfilled the item;
item-package-weight (get_fba_estimated_fba_fees_txt_data)NUMERICitem-package-weight (get_fba_estimated_fba_fees_txt_data)
length-and-girth (get_fba_estimated_fba_fees_txt_data)NUMERIClength-and-girth (get_fba_estimated_fba_fees_txt_data) The longest; side of your product, including its packaging, plus the girth, a unit; measure, equivalent to 2 x (median side + shortest side);
longest-side (get_fba_estimated_fba_fees_txt_data)NUMERIClongest-side (get_fba_estimated_fba_fees_txt_data) Measurement of the; longest side of your product including its packaging;
median-side (get_fba_estimated_fba_fees_txt_data)NUMERICmedian-side (get_fba_estimated_fba_fees_txt_data) Measurement of the; side that is neither the longest nor the shortest side of your product; including its packaging;
product-group (get_fba_estimated_fba_fees_txt_data)TEXTproduct-group (get_fba_estimated_fba_fees_txt_data) The Amazon; department or category;
product-name (get_fba_estimated_fba_fees_txt_data)TEXTproduct-name (get_fba_estimated_fba_fees_txt_data) The title of your; product;
product-size-tier (get_fba_estimated_fba_fees_txt_data)TEXTproduct-size-tier (get_fba_estimated_fba_fees_txt_data) The size tier; assigned to your product by FBA based on its dimensions and weight;
sales-price (get_fba_estimated_fba_fees_txt_data)NUMERICsales-price (get_fba_estimated_fba_fees_txt_data) Your current; promotional price;
shortest-side (get_fba_estimated_fba_fees_txt_data)NUMERICshortest-side (get_fba_estimated_fba_fees_txt_data) Measurement of the; shortest side of your product including its packaging;
sku (get_fba_estimated_fba_fees_txt_data)TEXTsku (get_fba_estimated_fba_fees_txt_data) Stock Keeping Units (SKUs); are unique blocks of letters or numbers that identify your products.; SKUs are assigned by you as the seller.;
unit-of-dimension (get_fba_estimated_fba_fees_txt_data)TEXTunit-of-dimension (get_fba_estimated_fba_fees_txt_data)
unit-of-weight (get_fba_estimated_fba_fees_txt_data)TEXTunit-of-weight (get_fba_estimated_fba_fees_txt_data) The unit of; weight used in weight measurement;
your-price (get_fba_estimated_fba_fees_txt_data)NUMERICyour-price (get_fba_estimated_fba_fees_txt_data) Your current selling; price;
asin (get_fba_fulfillment_customer_returns_data)TEXTasin (get_fba_fulfillment_customer_returns_data) Amazon standard item; number;
customer-comments (get_fba_fulfillment_customer_returns_data)TEXTcustomer-comments (get_fba_fulfillment_customer_returns_data) When; available, comments submitted by customers regarding the reason for; the return are provided.;
detailed-disposition (get_fba_fulfillment_customer_returns_data)TEXTdetailed-disposition (get_fba_fulfillment_customer_returns_data); Condition of the returned item: see Condition Codes below for; explanation;
fnsku (get_fba_fulfillment_customer_returns_data)TEXTfnsku (get_fba_fulfillment_customer_returns_data) Fulfillment network; SKU;
fulfillment-center-id (get_fba_fulfillment_customer_returns_data)TEXTfulfillment-center-id (get_fba_fulfillment_customer_returns_data); Fulfillment center where the returned merchandise was processed;
license-plate-number (get_fba_fulfillment_customer_returns_data)TEXTlicense-plate-number (get_fba_fulfillment_customer_returns_data);
order-id (get_fba_fulfillment_customer_returns_data)TEXTorder-id (get_fba_fulfillment_customer_returns_data)
product-name (get_fba_fulfillment_customer_returns_data)TEXTproduct-name (get_fba_fulfillment_customer_returns_data) The name of; the product as it appears on Amazon;
quantity (get_fba_fulfillment_customer_returns_data)NUMERICquantity (get_fba_fulfillment_customer_returns_data) Number of units; of this item returned;
reason (get_fba_fulfillment_customer_returns_data)TEXTreason (get_fba_fulfillment_customer_returns_data) A short description; of reason for return as indicated by the customer.; See Customer Reason below for explanation;
return-date (get_fba_fulfillment_customer_returns_data)DATEreturn-date (get_fba_fulfillment_customer_returns_data) Date returned; merchandise was processed at the fulfillment center.; DD-MM-YYYY.;
sku (get_fba_fulfillment_customer_returns_data)TEXTsku (get_fba_fulfillment_customer_returns_data) Seller's item; identifier;
status (get_fba_fulfillment_customer_returns_data)TEXTstatus (get_fba_fulfillment_customer_returns_data) A short description; of the status of the customer return. Please see; Return Status below for explanation.;
asin (get_fba_inventory_planning_data)TEXTasin (get_fba_inventory_planning_data) Unique blocks of 10 letters or; numbers that Amazon assigns to the products that are sold through; Amazon;
asin-limit (get_fba_inventory_planning_data)NUMERICasin-limit (get_fba_inventory_planning_data)
condition (get_fba_inventory_planning_data)TEXTcondition (get_fba_inventory_planning_data) The condition of the unit; (for example, new or used);
currency (get_fba_inventory_planning_data)TEXTcurrency (get_fba_inventory_planning_data) The currency for the; estimated long-term storage fee charge;
fnsku (get_fba_inventory_planning_data)TEXTfnsku (get_fba_inventory_planning_data) Unique blocks of letters and; numbers that Amazon assigns to products that are stored in and; fulfilled from an Amazon fulfillment center;
in-bound-quantity (get_fba_inventory_planning_data)NUMERICin-bound-quantity (get_fba_inventory_planning_data)
inbound-recommend-quantity (get_fba_inventory_planning_data)NUMERICinbound-recommend-quantity (get_fba_inventory_planning_data)
inv-age-0-to-90-days (get_fba_inventory_planning_data)NUMERICinv-age-0-to-90-days (get_fba_inventory_planning_data)
inv-age-181-to-270-days (get_fba_inventory_planning_data)NUMERICinv-age-181-to-270-days (get_fba_inventory_planning_data)
inv-age-271-to-365-days (get_fba_inventory_planning_data)NUMERICinv-age-271-to-365-days (get_fba_inventory_planning_data)
inv-age-365-plus-days (get_fba_inventory_planning_data)NUMERICinv-age-365-plus-days (get_fba_inventory_planning_data)
inv-age-91-to-180-days (get_fba_inventory_planning_data)NUMERICinv-age-91-to-180-days (get_fba_inventory_planning_data)
is-hazmat (get_fba_inventory_planning_data)TEXTis-hazmat (get_fba_inventory_planning_data)
lowest-afn-new-price (get_fba_inventory_planning_data)NUMERIClowest-afn-new-price (get_fba_inventory_planning_data)
lowest-afn-used-price (get_fba_inventory_planning_data)NUMERIClowest-afn-used-price (get_fba_inventory_planning_data)
lowest-mfn-new-price (get_fba_inventory_planning_data)NUMERIClowest-mfn-new-price (get_fba_inventory_planning_data)
lowest-mfn-used-price (get_fba_inventory_planning_data)NUMERIClowest-mfn-used-price (get_fba_inventory_planning_data)
num-afn-new-sellers (get_fba_inventory_planning_data)NUMERICnum-afn-new-sellers (get_fba_inventory_planning_data)
num-afn-used-sellers (get_fba_inventory_planning_data)NUMERICnum-afn-used-sellers (get_fba_inventory_planning_data)
per-unit-volume (get_fba_inventory_planning_data)NUMERICper-unit-volume (get_fba_inventory_planning_data)
product-group (get_fba_inventory_planning_data)TEXTproduct-group (get_fba_inventory_planning_data) Distinct product; grouping distinguishing products like books, from watches or video; games;
product-name (get_fba_inventory_planning_data)TEXTproduct-name (get_fba_inventory_planning_data) The name of your; product;
projected-ltsf-12-mo (get_fba_inventory_planning_data)NUMERICprojected-ltsf-12-mo (get_fba_inventory_planning_data)
projected-ltsf-6-mo (get_fba_inventory_planning_data)NUMERICprojected-ltsf-6-mo (get_fba_inventory_planning_data)
qty-in-long-term-storage-program (get_fba_inventory_planning_data)NUMERICqty-in-long-term-storage-program (get_fba_inventory_planning_data);
qty-to-be-charged-ltsf-12-mo (get_fba_inventory_planning_data)NUMERICqty-to-be-charged-ltsf-12-mo (get_fba_inventory_planning_data);
qty-to-be-charged-ltsf-6-mo (get_fba_inventory_planning_data)NUMERICqty-to-be-charged-ltsf-6-mo (get_fba_inventory_planning_data);
qty-with-removals-in-progress (get_fba_inventory_planning_data)TEXTqty-with-removals-in-progress (get_fba_inventory_planning_data);
sales-price (get_fba_inventory_planning_data)NUMERICsales-price (get_fba_inventory_planning_data)
sales-rank (get_fba_inventory_planning_data)NUMERICsales-rank (get_fba_inventory_planning_data) The current rank for your; product. The change in sales rank value is the plus or minus change in; the past 7 days.;
sellable-quantity (get_fba_inventory_planning_data)NUMERICsellable-quantity (get_fba_inventory_planning_data)
sku (get_fba_inventory_planning_data)TEXTsku (get_fba_inventory_planning_data) Unique blocks of letters and; numbers that you assign to the products that you are selling;
snapshot-date (get_fba_inventory_planning_data)DATEsnapshot-date (get_fba_inventory_planning_data) The date the report; was generated;
total-quantity (get_fba_inventory_planning_data)NUMERICtotal-quantity (get_fba_inventory_planning_data)
units-shipped-last-180-days (get_fba_inventory_planning_data)NUMERICunits-shipped-last-180-days (get_fba_inventory_planning_data);
units-shipped-last-24-hrs (get_fba_inventory_planning_data)NUMERICunits-shipped-last-24-hrs (get_fba_inventory_planning_data)
units-shipped-last-30-days (get_fba_inventory_planning_data)NUMERICunits-shipped-last-30-days (get_fba_inventory_planning_data)
units-shipped-last-365-days (get_fba_inventory_planning_data)NUMERICunits-shipped-last-365-days (get_fba_inventory_planning_data);
units-shipped-last-7-days (get_fba_inventory_planning_data)NUMERICunits-shipped-last-7-days (get_fba_inventory_planning_data)
units-shipped-last-90-days (get_fba_inventory_planning_data)NUMERICunits-shipped-last-90-days (get_fba_inventory_planning_data)
unsellable-quantity (get_fba_inventory_planning_data)NUMERICunsellable-quantity (get_fba_inventory_planning_data)
weeks-of-cover-t180 (get_fba_inventory_planning_data)TEXTweeks-of-cover-t180 (get_fba_inventory_planning_data)
weeks-of-cover-t30 (get_fba_inventory_planning_data)TEXTweeks-of-cover-t30 (get_fba_inventory_planning_data) Your historical; trailing 30-day on-hand inventory average divided by your units sold; over the same time period divided by 4 weeks. If you sold 400 units of; a given item in the last 30 days (4 weeks) and had 100 sellable units; in fulfillment centers, your weeks of cover last 30 days would be 1.;
weeks-of-cover-t365 (get_fba_inventory_planning_data)TEXTweeks-of-cover-t365 (get_fba_inventory_planning_data)
weeks-of-cover-t7 (get_fba_inventory_planning_data)TEXTweeks-of-cover-t7 (get_fba_inventory_planning_data)
weeks-of-cover-t90 (get_fba_inventory_planning_data)TEXTweeks-of-cover-t90 (get_fba_inventory_planning_data) Your historical; trailing 90-day on-hand inventory average divided by your units sold; over the same time period divided by 12 weeks. If you sold 400 units; of a given item in the last 90 days (12 weeks) and had an average of; 10 sellable units in fulfillment centers, your weeks of cover last 90; days would be 3.33.;
your-price (get_fba_inventory_planning_data)NUMERICyour-price (get_fba_inventory_planning_data) Your listed price;
alert (get_fba_inventory_planning_data)TEXTalert (get_fba_inventory_planning_data) This is displayed when an item; has a low-traffic or low-conversion alert. Low traffic indicates; that a low number of potential buyers have seen the listing. Low; conversion indicates that potential buyers are viewing the listing but; aren’t following through to buy the product.;
available (get_fba_inventory_planning_data)NUMERICavailable (get_fba_inventory_planning_data) Available (sellable; inventory) quantity;
days-of-supply (get_fba_inventory_planning_data)NUMERICdays-of-supply (get_fba_inventory_planning_data) The estimated number; of days that your current inventory supply will last based on the; projected demand for your product;
NUMERICestimated-cost-savings-of-recommended-actions; (get_fba_inventory_planning_data) Estimated cost savings between; taking the recommended action versus the storage fees you would incur; on that inventory by taking no action;
estimated-excess-quantity (get_fba_inventory_planning_data)NUMERICestimated-excess-quantity (get_fba_inventory_planning_data) Estimated; excess units are overstocked units based on your current sales; velocity and customer demand forecast. It’s costing you more to keep; these units on hand and pay storage fees than to reduce the number of; units through a price reduction or removal.;
estimated-ltsf-next-charge (get_fba_inventory_planning_data)TEXTestimated-ltsf-next-charge (get_fba_inventory_planning_data)
estimated-storage-cost-next-month (get_fba_inventory_planning_data)NUMERICestimated-storage-cost-next-month (get_fba_inventory_planning_data); Estimated storage fees (monthly storage + long-term storage) that you; would incur 30 days from today, based on your current sales rate.; Note: Inventory costs are based on quantities in the latest daily; snapshot and may differ from your actual inventory quantities.;
featuredoffer-price (get_fba_inventory_planning_data)NUMERICfeaturedoffer-price (get_fba_inventory_planning_data) Offer displayed; on a product detail page with an Add to Cart button;
healthy-inventory-level (get_fba_inventory_planning_data)NUMERIChealthy-inventory-level (get_fba_inventory_planning_data) Quantity of; inventory that is not considered excess based on product demand and; your costs. Our recommendations are based on helping you reach this; level of inventory.;
inbound-quantity (get_fba_inventory_planning_data)NUMERICinbound-quantity (get_fba_inventory_planning_data) Inbound quantity =; inbound-working + inbound-shipped + inbound receiving;
inbound-received (get_fba_inventory_planning_data)NUMERICinbound-received (get_fba_inventory_planning_data) Shipments in; receiving status;
inbound-shipped (get_fba_inventory_planning_data)NUMERICinbound-shipped (get_fba_inventory_planning_data) Shipments in shipped; status;
inbound-working (get_fba_inventory_planning_data)NUMERICinbound-working (get_fba_inventory_planning_data) Shipments in working; status;
inv-age-0-to-30-days (get_fba_inventory_planning_data)TEXTinv-age-0-to-30-days (get_fba_inventory_planning_data)
inv-age-181-to-330-days (get_fba_inventory_planning_data)TEXTinv-age-181-to-330-days (get_fba_inventory_planning_data)
inv-age-31-to-60-days (get_fba_inventory_planning_data)TEXTinv-age-31-to-60-days (get_fba_inventory_planning_data)
inv-age-331-to-365-days (get_fba_inventory_planning_data)TEXTinv-age-331-to-365-days (get_fba_inventory_planning_data)
inv-age-61-to-90-days (get_fba_inventory_planning_data)TEXTinv-age-61-to-90-days (get_fba_inventory_planning_data)
item-volume (get_fba_inventory_planning_data)NUMERICitem-volume (get_fba_inventory_planning_data) The volume of the item,; which is calculated by multiplying the longest side, median side, and; shortest side together. These measurements generally correspond to the; length, width, and height of the item.;
lowest-price-new-plus-shipping (get_fba_inventory_planning_data)TEXTlowest-price-new-plus-shipping (get_fba_inventory_planning_data);
lowest-price-used (get_fba_inventory_planning_data)TEXTlowest-price-used (get_fba_inventory_planning_data)
marketplace (get_fba_inventory_planning_data)TEXTmarketplace (get_fba_inventory_planning_data) The Amazon store where; the product is located;
no-sale-last-6-months (get_fba_inventory_planning_data)NUMERICno-sale-last-6-months (get_fba_inventory_planning_data) Inventory that; has not sold in six or more consecutive months and that have been in; fulfillment centers for more than 180 days. These units will be; automatically removed during the next removal cycle if you are opted; in to automated fulfillable inventory removals.;
pending-removal-quantity (get_fba_inventory_planning_data)NUMERICpending-removal-quantity (get_fba_inventory_planning_data) The number; of units that you have asked to be returned to you or disposed of;
projected-ltsf-9-mo (get_fba_inventory_planning_data)TEXTprojected-ltsf-9-mo (get_fba_inventory_planning_data)
qty-to-be-charged-ltsf-9-mo (get_fba_inventory_planning_data)TEXTqty-to-be-charged-ltsf-9-mo (get_fba_inventory_planning_data);
TEXTrecommended-action (get_fba_inventory_planning_data) The action; recommended for your inventory. Recommendations are based on your; current customer demand and on whether it would cost you less to take; an action than to do nothing.;
NUMERICrecommended-removal-quantity (get_fba_inventory_planning_data); Estimated number of units that would likely benefit from removal; instead of being charged storage fees;
NUMERICrecommended-sale-duration-days (get_fba_inventory_planning_data) If a; sale is recommended, this is the estimated sale duration in days that; would likely help you sell through your excess inventory.;
NUMERICrecommended-sales-price (get_fba_inventory_planning_data) Sales price; recommended to help you sell through your inventory based on your; current inventory settings. This value may be different from the; lowest price or Featured Offer price. We recommend that you keep your; product at this price until you have sold through your excess; inventory.;
sales-shipped-last-30-days (get_fba_inventory_planning_data)NUMERICsales-shipped-last-30-days (get_fba_inventory_planning_data) Shipped-; unit sales in the last 30 days;
sales-shipped-last-60-days (get_fba_inventory_planning_data)NUMERICsales-shipped-last-60-days (get_fba_inventory_planning_data) Shipped-; unit sales in the last 60 days;
sales-shipped-last-7-days (get_fba_inventory_planning_data)NUMERICsales-shipped-last-7-days (get_fba_inventory_planning_data) Shipped-; unit sales in the last 7 days;
sales-shipped-last-90-days (get_fba_inventory_planning_data)NUMERICsales-shipped-last-90-days (get_fba_inventory_planning_data) Shipped-; unit sales in the last 90 days;
sell-through (get_fba_inventory_planning_data)NUMERICsell-through (get_fba_inventory_planning_data) The rate at which your; units sold and shipped over the past 90 days divided by the average; inventory available at fulfillment centers during that time. Tracking; your sell-through rate can help you determine whether you need to take; action to improve traffic or conversion for your products.;
storage-type (get_fba_inventory_planning_data)TEXTstorage-type (get_fba_inventory_planning_data) Storage-type category; of the product for which storage limits are set. Note: Standard size; includes small and standard types.;
storage-volume (get_fba_inventory_planning_data)NUMERICstorage-volume (get_fba_inventory_planning_data) Storage volume is the; total usage for this product in our fulfillment centers minus; inventory that is pending removal;
units-shipped-t30 (get_fba_inventory_planning_data)NUMERICunits-shipped-t30 (get_fba_inventory_planning_data) Units shipped in; the last 30 days;
units-shipped-t60 (get_fba_inventory_planning_data)NUMERICunits-shipped-t60 (get_fba_inventory_planning_data) Units shipped in; the last 60 days;
units-shipped-t7 (get_fba_inventory_planning_data)NUMERICunits-shipped-t7 (get_fba_inventory_planning_data) Units shipped in; the last 7 days;
units-shipped-t90 (get_fba_inventory_planning_data)NUMERICunits-shipped-t90 (get_fba_inventory_planning_data) Units shipped in; the last 90 days;
volume-unit-measurement (get_fba_inventory_planning_data)TEXTvolume-unit-measurement (get_fba_inventory_planning_data) Unit of; measurement for the volume of the item;
afn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data)NUMERICafn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data) The; number of units you have for a SKU in Amazon fulfillment centers; that can be picked, packed, and shipped.;
afn-future-supply-buyable (get_fba_myi_unsuppressed_inventory_data)NUMERICafn-future-supply-buyable (get_fba_myi_unsuppressed_inventory_data); The number of units available for customers to find and buy while; inventory is on its way to an Amazon fulfillment center through In-; Stock Head Start.;
afn-inbound-receiving-quantity (get_fba_myi_unsuppressed_inventory_data)NUMERICafn-inbound-receiving-quantity; (get_fba_myi_unsuppressed_inventory_data) The number of units you have; for a SKU that have not yet been received at; an Amazon fulfillment center for processing, but are part of an; inbound shipment with some units that have; already been received and processed.;
afn-inbound-shipped-quantity (get_fba_myi_unsuppressed_inventory_data)NUMERICafn-inbound-shipped-quantity (get_fba_myi_unsuppressed_inventory_data); The number of units you have for a SKU in an inbound shipment that you; have notified Amazon about and provided a tracking number.;
afn-inbound-working-quantity (get_fba_myi_unsuppressed_inventory_data)NUMERICafn-inbound-working-quantity (get_fba_myi_unsuppressed_inventory_data); The number of units you have for a SKU in an inbound shipment that you; have notified Amazon about.;
afn-listing-exists (get_fba_myi_unsuppressed_inventory_data)TEXTafn-listing-exists (get_fba_myi_unsuppressed_inventory_data) "Yes"; indicates that the item is listed for Fulfillment by; Amazon.;
afn-researching-quantity (get_fba_myi_unsuppressed_inventory_data)NUMERICafn-researching-quantity (get_fba_myi_unsuppressed_inventory_data);
afn-reserved-future-supply (get_fba_myi_unsuppressed_inventory_data)NUMERICafn-reserved-future-supply (get_fba_myi_unsuppressed_inventory_data); The number of units that customers have purchased while inventory is; on its way to an Amazon fulfillment center; through In-Stock Head Start.;
afn-reserved-quantity (get_fba_myi_unsuppressed_inventory_data)NUMERICafn-reserved-quantity (get_fba_myi_unsuppressed_inventory_data) The; number of units you have for a SKU in Amazon fulfillment centers; that are currently being picked, packed, and shipped or are sidelined; for measurement, sampling, or other internal; processes.;
afn-total-quantity (get_fba_myi_unsuppressed_inventory_data)NUMERICafn-total-quantity (get_fba_myi_unsuppressed_inventory_data) The total; number of units you have for a SKU in an inbound shipment or; in Amazon fulfillment centers: (afn-total-quantity) =; (afn-warehouse-quantity) + (afn-inbound-working-quantity) +; (afn-inbound-shipped-quantity) + (afn-inbound-receiving-quantity);
afn-unsellable-quantity (get_fba_myi_unsuppressed_inventory_data)NUMERICafn-unsellable-quantity (get_fba_myi_unsuppressed_inventory_data) The; number of units you have for a SKU in Amazon fulfillment centers in; unsellable condition.;
afn-warehouse-quantity (get_fba_myi_unsuppressed_inventory_data)NUMERICafn-warehouse-quantity (get_fba_myi_unsuppressed_inventory_data) The; number of units you have for an SKU in Amazon fulfillment centers; that have been processed: (afn-warehouse-quantity) =; (afn-fulfillable-quantity) + (afn-unsellable-quantity) +; (afn-reserved-quantity).;
asin (get_fba_myi_unsuppressed_inventory_data)TEXTasin (get_fba_myi_unsuppressed_inventory_data) Amazon Standard; Identification Numbers (ASINs) are unique blocks of 10; letters or numbers that identify items. ASINs are assigned by Amazon.; You can find the ASIN on the product detail; page.;
condition (get_fba_myi_unsuppressed_inventory_data)TEXTcondition (get_fba_myi_unsuppressed_inventory_data) The condition of; your product.;
fnsku (get_fba_myi_unsuppressed_inventory_data)TEXTfnsku (get_fba_myi_unsuppressed_inventory_data) Fulfillment Network; Stock Keeping Units (FNSKUs) are unique identifiers; assigned by Amazon to products stored in and fulfilled from Amazon; fulfillment centers.;
mfn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data)TEXTmfn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data) The; quantity in your fulfillment network that can be picked, packed, and; shipped.;
mfn-listing-exists (get_fba_myi_unsuppressed_inventory_data)TEXTmfn-listing-exists (get_fba_myi_unsuppressed_inventory_data) "Yes"; indicates that the product is listed for fulfillment by you as the; seller.;
per-unit-volume (get_fba_myi_unsuppressed_inventory_data)NUMERICper-unit-volume (get_fba_myi_unsuppressed_inventory_data) The volume; in cubic feet of one unit (to the nearest; 1/100 of an inch).;
product-name (get_fba_myi_unsuppressed_inventory_data)TEXTproduct-name (get_fba_myi_unsuppressed_inventory_data) The title of; your product.;
sku (get_fba_myi_unsuppressed_inventory_data)TEXTsku (get_fba_myi_unsuppressed_inventory_data) Stock Keeping Units; (SKUs) are unique blocks of letters or numbers that; identify your products.;
your-price (get_fba_myi_unsuppressed_inventory_data)NUMERICyour-price (get_fba_myi_unsuppressed_inventory_data) Your current; selling price.;
amazon-order-id (get_fba_reimbursements_data)TEXTamazon-order-id (get_fba_reimbursements_data) The unique identifier; assigned to the customer order. This field is; empty if the reimbursement is not associated with an order.;
amount-per-unit (get_fba_reimbursements_data)NUMERICamount-per-unit (get_fba_reimbursements_data) The per-unit; reimbursement amount for this line item.;
amount-total (get_fba_reimbursements_data)NUMERICamount-total (get_fba_reimbursements_data) The total amount of the; cash reimbursement for this line item.;
approval-date (get_fba_reimbursements_data)DATEapproval-date (get_fba_reimbursements_data) The date the reimbursement; was approved.;
asin (get_fba_reimbursements_data)TEXTasin (get_fba_reimbursements_data) An ASIN (Amazon Standard; Identification Numbers) is a unique identifier; assigned by Amazon to products in the Amazon product catalog. The ASIN; can be found on the product detail page.;
case-id (get_fba_reimbursements_data)TEXTcase-id (get_fba_reimbursements_data) The unique identifier assigned; to the case when you request a reimbursement.;
condition (get_fba_reimbursements_data)TEXTcondition (get_fba_reimbursements_data) The condition of your item; (for example, New).;
currency-unit (get_fba_reimbursements_data)TEXTcurrency-unit (get_fba_reimbursements_data) The currency for the; applicable marketplace.;
fnsku (get_fba_reimbursements_data)TEXTfnsku (get_fba_reimbursements_data) The fulfillment network SKU (stock; keeping unit) is the unique identifier; Fulfillment by Amazon assigned to your product.;
original-reimbursement-id (get_fba_reimbursements_data)TEXToriginal-reimbursement-id (get_fba_reimbursements_data)
original-reimbursement-type (get_fba_reimbursements_data)TEXToriginal-reimbursement-type (get_fba_reimbursements_data)
product-name (get_fba_reimbursements_data)TEXTproduct-name (get_fba_reimbursements_data) The name of your product.;
quantity-reimbursed-cash (get_fba_reimbursements_data)NUMERICquantity-reimbursed-cash (get_fba_reimbursements_data) The total; number of units reimbursed with cash.;
quantity-reimbursed-inventory (get_fba_reimbursements_data)NUMERICquantity-reimbursed-inventory (get_fba_reimbursements_data) The number; of units reimbursed with inventory.;
quantity-reimbursed-total (get_fba_reimbursements_data)NUMERICquantity-reimbursed-total (get_fba_reimbursements_data) The total; number of units reimbursed with either cash or inventory; (Quantity Reimbursed [Cash] + Quantity Reimbursed [Inventory]).;
reason (get_fba_reimbursements_data)TEXTreason (get_fba_reimbursements_data) The reason for the reimbursement; (for example, Damaged: Warehouse).;
reimbursement-id (get_fba_reimbursements_data)TEXTreimbursement-id (get_fba_reimbursements_data) The unique identifier; for this reimbursement. Each reimbursement may; include multiple line items.;
sku (get_fba_reimbursements_data)TEXTsku (get_fba_reimbursements_data)
asin (get_fba_uno_inventory_data)TEXTasin (get_fba_uno_inventory_data)
price (get_fba_uno_inventory_data)NUMERICprice (get_fba_uno_inventory_data)
quantity (get_fba_uno_inventory_data)NUMERICquantity (get_fba_uno_inventory_data)
sku (get_fba_uno_inventory_data)TEXTsku (get_fba_uno_inventory_data)
amazon-order-id (get_flat_file_all_orders_data_by_last_update_general)TEXTamazon-order-id (get_flat_file_all_orders_data_by_last_update_general);
asin (get_flat_file_all_orders_data_by_last_update_general)TEXTasin (get_flat_file_all_orders_data_by_last_update_general)
currency (get_flat_file_all_orders_data_by_last_update_general)TEXTcurrency (get_flat_file_all_orders_data_by_last_update_general); Currency type Example: USD;
fulfillment-channel (get_flat_file_all_orders_data_by_last_update_general)TEXTfulfillment-channel; (get_flat_file_all_orders_data_by_last_update_general);
gift-wrap-price (get_flat_file_all_orders_data_by_last_update_general)NUMERICgift-wrap-price (get_flat_file_all_orders_data_by_last_update_general); The price of the gift wrap selected by the buyer.;
gift-wrap-tax (get_flat_file_all_orders_data_by_last_update_general)NUMERICgift-wrap-tax (get_flat_file_all_orders_data_by_last_update_general); The amount of tax paid on the gift wrap.;
is-business-order (get_flat_file_all_orders_data_by_last_update_general)TEXTis-business-order; (get_flat_file_all_orders_data_by_last_update_general) Indicates if; the order is from an Amazon Business customer.Example: true, false;
item-price (get_flat_file_all_orders_data_by_last_update_general)NUMERICitem-price (get_flat_file_all_orders_data_by_last_update_general); Price a buyer paid for the item(s). All amounts are aggregates of the; quantity, not unit prices.Example: Item Price = $10 Quantity = 2 Item; price displayed = $20;
item-promotion-discount (get_flat_file_all_orders_data_by_last_update_general)TEXTitem-promotion-discount; (get_flat_file_all_orders_data_by_last_update_general) Amount; discounted from orders that qualify for either a money-off or a; percent-off promotion.;
item-status (get_flat_file_all_orders_data_by_last_update_general)TEXTitem-status (get_flat_file_all_orders_data_by_last_update_general);
item-tax (get_flat_file_all_orders_data_by_last_update_general)NUMERICitem-tax (get_flat_file_all_orders_data_by_last_update_general);
last-updated-date (get_flat_file_all_orders_data_by_last_update_general)DATElast-updated-date; (get_flat_file_all_orders_data_by_last_update_general);
merchant-order-id (get_flat_file_all_orders_data_by_last_update_general)TEXTmerchant-order-id; (get_flat_file_all_orders_data_by_last_update_general);
order-channel (get_flat_file_all_orders_data_by_last_update_general)TEXTorder-channel (get_flat_file_all_orders_data_by_last_update_general); Information about how an order was placed.;
order-status (get_flat_file_all_orders_data_by_last_update_general)TEXTorder-status (get_flat_file_all_orders_data_by_last_update_general);
price-designation (get_flat_file_all_orders_data_by_last_update_general)TEXTprice-designation; (get_flat_file_all_orders_data_by_last_update_general) Indicates the; type of business price that the buyer used. Learn more about business; prices. (Amazon Business Seller Program only.);
product-name (get_flat_file_all_orders_data_by_last_update_general)TEXTproduct-name (get_flat_file_all_orders_data_by_last_update_general); Short title for the product, displayed on the product detail page and; in the browser title bar.Example: Snowboard;
promotion-ids (get_flat_file_all_orders_data_by_last_update_general)TEXTpromotion-ids (get_flat_file_all_orders_data_by_last_update_general);
purchase-date (get_flat_file_all_orders_data_by_last_update_general)DATEpurchase-date (get_flat_file_all_orders_data_by_last_update_general); Date the order was placed, in yyyy-mm-dd format. Note: Unless you; specify a different shipping lead time, you have agreed to ship the; order within two business days of this date.;
purchase-order-number (get_flat_file_all_orders_data_by_last_update_general)TEXTpurchase-order-number; (get_flat_file_all_orders_data_by_last_update_general) The buyer's; purchase order number (for orders from Amazon Business customers).; This must be included on the customer package packing slip or on the; package shipping label. For more information on packing slips and; purchase order numbers, click here.;
quantity (get_flat_file_all_orders_data_by_last_update_general)TEXTquantity (get_flat_file_all_orders_data_by_last_update_general);
sales-channel (get_flat_file_all_orders_data_by_last_update_general)TEXTsales-channel (get_flat_file_all_orders_data_by_last_update_general);
ship-city (get_flat_file_all_orders_data_by_last_update_general)CITYship-city (get_flat_file_all_orders_data_by_last_update_general) City; of "Ship To" address.;
ship-country (get_flat_file_all_orders_data_by_last_update_general)COUNTRYship-country (get_flat_file_all_orders_data_by_last_update_general); International Standards Organization two-letter country code (ISO; 3166-2 compliant).Example: US;
ship-postal-code (get_flat_file_all_orders_data_by_last_update_general)TEXTship-postal-code; (get_flat_file_all_orders_data_by_last_update_general) ZIP code or; postal code of "Ship To" address. Value format depends on destination; country.;
ship-promotion-discount (get_flat_file_all_orders_data_by_last_update_general)TEXTship-promotion-discount; (get_flat_file_all_orders_data_by_last_update_general);
ship-service-level (get_flat_file_all_orders_data_by_last_update_general)TEXTship-service-level; (get_flat_file_all_orders_data_by_last_update_general) Type of; shipping selected by the buyer when ordering the item; for example,; standard, expedited.;
ship-state (get_flat_file_all_orders_data_by_last_update_general)TEXTship-state (get_flat_file_all_orders_data_by_last_update_general); State, province, or region of "Ship To" address. Varies with country; of origin. Note: Abbreviations can vary depending on how it was; entered by the buyer.;
shipping-price (get_flat_file_all_orders_data_by_last_update_general)NUMERICshipping-price (get_flat_file_all_orders_data_by_last_update_general); Price a buyer paid for shipping. All amounts are aggregates of the; quantity, not unit prices.;
shipping-tax (get_flat_file_all_orders_data_by_last_update_general)TEXTshipping-tax (get_flat_file_all_orders_data_by_last_update_general);
sku (get_flat_file_all_orders_data_by_last_update_general)TEXTsku (get_flat_file_all_orders_data_by_last_update_general) Stock; Keeping Unit. The seller-defined unique identifier for a product.; Example: AA786936215595;
amazon-order-id (get_flat_file_all_orders_data_by_order_date_general)TEXTamazon-order-id (get_flat_file_all_orders_data_by_order_date_general);
asin (get_flat_file_all_orders_data_by_order_date_general)TEXTasin (get_flat_file_all_orders_data_by_order_date_general)
currency (get_flat_file_all_orders_data_by_order_date_general)TEXTcurrency (get_flat_file_all_orders_data_by_order_date_general); Currency type Example: USD;
fulfillment-channel (get_flat_file_all_orders_data_by_order_date_general)TEXTfulfillment-channel; (get_flat_file_all_orders_data_by_order_date_general);
gift-wrap-price (get_flat_file_all_orders_data_by_order_date_general)NUMERICgift-wrap-price (get_flat_file_all_orders_data_by_order_date_general); The price of the gift wrap selected by the buyer.;
gift-wrap-tax (get_flat_file_all_orders_data_by_order_date_general)NUMERICgift-wrap-tax (get_flat_file_all_orders_data_by_order_date_general); The amount of tax paid on the gift wrap.;
is-business-order (get_flat_file_all_orders_data_by_order_date_general)TEXTis-business-order; (get_flat_file_all_orders_data_by_order_date_general) Indicates if the; order is from an Amazon Business customer.Example: true, false;
item-price (get_flat_file_all_orders_data_by_order_date_general)NUMERICitem-price (get_flat_file_all_orders_data_by_order_date_general) Price; a buyer paid for the item(s). All amounts are aggregates of the; quantity, not unit prices.Example: Item Price = $10 Quantity = 2 Item; price displayed = $20;
item-promotion-discount (get_flat_file_all_orders_data_by_order_date_general)TEXTitem-promotion-discount; (get_flat_file_all_orders_data_by_order_date_general) Amount; discounted from orders that qualify for either a money-off or a; percent-off promotion.;
item-status (get_flat_file_all_orders_data_by_order_date_general)TEXTitem-status (get_flat_file_all_orders_data_by_order_date_general);
item-tax (get_flat_file_all_orders_data_by_order_date_general)NUMERICitem-tax (get_flat_file_all_orders_data_by_order_date_general);
last-updated-date (get_flat_file_all_orders_data_by_order_date_general)DATElast-updated-date; (get_flat_file_all_orders_data_by_order_date_general);
merchant-order-id (get_flat_file_all_orders_data_by_order_date_general)TEXTmerchant-order-id; (get_flat_file_all_orders_data_by_order_date_general);
order-channel (get_flat_file_all_orders_data_by_order_date_general)TEXTorder-channel (get_flat_file_all_orders_data_by_order_date_general); Information about how an order was placed.;
order-status (get_flat_file_all_orders_data_by_order_date_general)TEXTorder-status (get_flat_file_all_orders_data_by_order_date_general);
price-designation (get_flat_file_all_orders_data_by_order_date_general)TEXTprice-designation; (get_flat_file_all_orders_data_by_order_date_general) Indicates the; type of business price that the buyer used. Learn more about business; prices. (Amazon Business Seller Program only.);
product-name (get_flat_file_all_orders_data_by_order_date_general)TEXTproduct-name (get_flat_file_all_orders_data_by_order_date_general); Short title for the product, displayed on the product detail page and; in the browser title bar.Example: Snowboard;
promotion-ids (get_flat_file_all_orders_data_by_order_date_general)TEXTpromotion-ids (get_flat_file_all_orders_data_by_order_date_general);
purchase-date (get_flat_file_all_orders_data_by_order_date_general)TIMESTAMPpurchase-date (get_flat_file_all_orders_data_by_order_date_general); Date the order was placed, in yyyy-mm-dd format. Note: Unless you; specify a different shipping lead time, you have agreed to ship the; order within two business days of this date.;
purchase-order-number (get_flat_file_all_orders_data_by_order_date_general)TEXTpurchase-order-number; (get_flat_file_all_orders_data_by_order_date_general) The buyer's; purchase order number (for orders from Amazon Business customers).; This must be included on the customer package packing slip or on the; package shipping label. For more information on packing slips and; purchase order numbers, click here.;
quantity (get_flat_file_all_orders_data_by_order_date_general)TEXTquantity (get_flat_file_all_orders_data_by_order_date_general);
sales-channel (get_flat_file_all_orders_data_by_order_date_general)TEXTsales-channel (get_flat_file_all_orders_data_by_order_date_general);
ship-city (get_flat_file_all_orders_data_by_order_date_general)CITYship-city (get_flat_file_all_orders_data_by_order_date_general) City; of "Ship To" address.;
ship-country (get_flat_file_all_orders_data_by_order_date_general)COUNTRYship-country (get_flat_file_all_orders_data_by_order_date_general); International Standards Organization two-letter country code (ISO; 3166-2 compliant).Example: US;
ship-postal-code (get_flat_file_all_orders_data_by_order_date_general)TEXTship-postal-code (get_flat_file_all_orders_data_by_order_date_general); ZIP code or postal code of "Ship To" address. Value format depends on; destination country.;
ship-promotion-discount (get_flat_file_all_orders_data_by_order_date_general)TEXTship-promotion-discount; (get_flat_file_all_orders_data_by_order_date_general);
ship-service-level (get_flat_file_all_orders_data_by_order_date_general)TEXTship-service-level; (get_flat_file_all_orders_data_by_order_date_general) Type of shipping; selected by the buyer when ordering the item; for example, standard,; expedited.;
ship-state (get_flat_file_all_orders_data_by_order_date_general)TEXTship-state (get_flat_file_all_orders_data_by_order_date_general); State, province, or region of "Ship To" address. Varies with country; of origin. Note: Abbreviations can vary depending on how it was; entered by the buyer.;
shipping-price (get_flat_file_all_orders_data_by_order_date_general)NUMERICshipping-price (get_flat_file_all_orders_data_by_order_date_general); Price a buyer paid for shipping. All amounts are aggregates of the; quantity, not unit prices.;
shipping-tax (get_flat_file_all_orders_data_by_order_date_general)TEXTshipping-tax (get_flat_file_all_orders_data_by_order_date_general);
sku (get_flat_file_all_orders_data_by_order_date_general)TEXTsku (get_flat_file_all_orders_data_by_order_date_general) Stock; Keeping Unit. The seller-defined unique identifier for a product.; Example: AA786936215595;
asin (get_flat_file_open_listings_data)TEXTasin (get_flat_file_open_listings_data)
Business Price (get_flat_file_open_listings_data)TEXTBusiness Price (get_flat_file_open_listings_data)
price (get_flat_file_open_listings_data)NUMERICprice (get_flat_file_open_listings_data)
Progressive Lower Bound 1 (get_flat_file_open_listings_data)TEXTProgressive Lower Bound 1 (get_flat_file_open_listings_data)
Progressive Lower Bound 2 (get_flat_file_open_listings_data)TEXTProgressive Lower Bound 2 (get_flat_file_open_listings_data)
Progressive Lower Bound 3 (get_flat_file_open_listings_data)TEXTProgressive Lower Bound 3 (get_flat_file_open_listings_data)
Progressive Price 1 (get_flat_file_open_listings_data)TEXTProgressive Price 1 (get_flat_file_open_listings_data)
Progressive Price 2 (get_flat_file_open_listings_data)TEXTProgressive Price 2 (get_flat_file_open_listings_data)
Progressive Price 3 (get_flat_file_open_listings_data)TEXTProgressive Price 3 (get_flat_file_open_listings_data)
Progressive Price Type (get_flat_file_open_listings_data)TEXTProgressive Price Type (get_flat_file_open_listings_data)
quantity (get_flat_file_open_listings_data)NUMERICquantity (get_flat_file_open_listings_data)
Quantity Lower Bound 1 (get_flat_file_open_listings_data)TEXTQuantity Lower Bound 1 (get_flat_file_open_listings_data)
Quantity Lower Bound 2 (get_flat_file_open_listings_data)TEXTQuantity Lower Bound 2 (get_flat_file_open_listings_data)
Quantity Lower Bound 3 (get_flat_file_open_listings_data)TEXTQuantity Lower Bound 3 (get_flat_file_open_listings_data)
Quantity Lower Bound 4 (get_flat_file_open_listings_data)TEXTQuantity Lower Bound 4 (get_flat_file_open_listings_data)
Quantity Lower Bound 5 (get_flat_file_open_listings_data)TEXTQuantity Lower Bound 5 (get_flat_file_open_listings_data)
Quantity Price 1 (get_flat_file_open_listings_data)TEXTQuantity Price 1 (get_flat_file_open_listings_data)
Quantity Price 2 (get_flat_file_open_listings_data)TEXTQuantity Price 2 (get_flat_file_open_listings_data)
Quantity Price 3 (get_flat_file_open_listings_data)TEXTQuantity Price 3 (get_flat_file_open_listings_data)
Quantity Price 4 (get_flat_file_open_listings_data)TEXTQuantity Price 4 (get_flat_file_open_listings_data)
Quantity Price 5 (get_flat_file_open_listings_data)TEXTQuantity Price 5 (get_flat_file_open_listings_data)
Quantity Price Type (get_flat_file_open_listings_data)TEXTQuantity Price Type (get_flat_file_open_listings_data)
sku (get_flat_file_open_listings_data)TEXTsku (get_flat_file_open_listings_data)
Marketplace CountryCOUNTRYThe Marketplace Country
add-delete (get_merchant_listings_all_data)TEXTadd-delete (get_merchant_listings_all_data) This field will be empty; in the report; it enables you to use an open listings report to update; online inventory.;
asin1 (get_merchant_listings_all_data)TEXTasin1 (get_merchant_listings_all_data) This is not used. The field is; populated with the product-id.;
asin2 (get_merchant_listings_all_data)TEXTasin2 (get_merchant_listings_all_data) This is used for backwards; compatibility only.;
asin3 (get_merchant_listings_all_data)TEXTasin3 (get_merchant_listings_all_data) This is used for backwards; compatibility only.;
TEXTbid-for-featured-placement (get_merchant_listings_all_data) This is; used for backwards compatibility only.;
expedited-shipping (get_merchant_listings_all_data)TEXTexpedited-shipping (get_merchant_listings_all_data) Second = listings; that are available for second day shipping to U.S. domestic addresses; Next = listings that are available for next day shipping to U.S.; domestic addresses Same = listings that are available for same day; shipping to U.S. domestic addresses n = not offered;
fulfillment-channel (get_merchant_listings_all_data)TEXTfulfillment-channel (get_merchant_listings_all_data) This will; indicate for FBA sellers if the listing is set for seller fulfilment; or fulfilment by Amazon.;
image-url (get_merchant_listings_all_data)TEXTimage-url (get_merchant_listings_all_data)
item-condition (get_merchant_listings_all_data)NUMERICitem-condition (get_merchant_listings_all_data) This is your condition; code for the listing.1 = Used; Like New 2 = Used; Very Good 3 = Used;; Good 4 = Used; Acceptable 5 = Collectible; Like New 6 = Collectible;; Very Good 7 = Collectible; Good 8 = Collectible; Acceptable 10 =; Refurbished 11 = New;
item-description (get_merchant_listings_all_data)TEXTitem-description (get_merchant_listings_all_data) This is used for; backwards compatibility only.;
item-is-marketplace (get_merchant_listings_all_data)TEXTitem-is-marketplace (get_merchant_listings_all_data) This will always; be y.;
item-name (get_merchant_listings_all_data)TEXTitem-name (get_merchant_listings_all_data) The title of the item; listed. This will be populated with Amazon catalog data.;
item-note (get_merchant_listings_all_data)TEXTitem-note (get_merchant_listings_all_data) Your description of the; listing.;
listing-id (get_merchant_listings_all_data)TEXTlisting-id (get_merchant_listings_all_data) An identifier created by; Amazon when you create a listing. Consists of 4 digits, a capital; letter, and 6 more digits.;
merchant-shipping-group (get_merchant_listings_all_data)TEXTmerchant-shipping-group (get_merchant_listings_all_data)
open-date (get_merchant_listings_all_data)DATEopen-date (get_merchant_listings_all_data) The date the listing was; created.;
pending-quantity (get_merchant_listings_all_data)TEXTpending-quantity (get_merchant_listings_all_data) This is the quantity; of the item that is pending purchase at the time of the report.;
price (get_merchant_listings_all_data)NUMERICprice (get_merchant_listings_all_data) The price you are asking for; the product.;
product-id (get_merchant_listings_all_data)TEXTproduct-id (get_merchant_listings_all_data) ASIN, ISBN, UPC, or EAN; for the item;
product-id-type (get_merchant_listings_all_data)NUMERICproduct-id-type (get_merchant_listings_all_data) A numeric entry that; indicates if the product-id is an ASIN, ISBN, UPC, or EAN code/number.; When uploading files in Standard Book format, this field value will; default to 2 (ISBN) unless otherwise specified.1 = ASIN 2 = ISBN 3 =; UPC 4 = EAN;
quantity (get_merchant_listings_all_data)TEXTquantity (get_merchant_listings_all_data) The quantity of the product; available for purchase.;
seller-sku (get_merchant_listings_all_data)TEXTseller-sku (get_merchant_listings_all_data) Stock Keeping Units (SKUs); are unique blocks of letters and/or numbers that identify your; products. SKUs are assigned by you as the seller.;
status (get_merchant_listings_all_data)TEXTstatus (get_merchant_listings_all_data)
will-ship-internationally (get_merchant_listings_all_data)TEXTwill-ship-internationally (get_merchant_listings_all_data) 2 =; listings that are available to customers outside the U.S.1 = listings; that are available only to customers in the U.S.;
zshop-boldface (get_merchant_listings_all_data)TEXTzshop-boldface (get_merchant_listings_all_data) This is used for; backwards compatibility only.;
zshop-browse-path (get_merchant_listings_all_data)TEXTzshop-browse-path (get_merchant_listings_all_data) This is used for; backwards compatibility only.;
zshop-category1 (get_merchant_listings_all_data)TEXTzshop-category1 (get_merchant_listings_all_data) This is used for; backwards compatibility only.;
zshop-shipping-fee (get_merchant_listings_all_data)TEXTzshop-shipping-fee (get_merchant_listings_all_data) This is used for; backwards compatibility only.;
zshop-storefront-feature (get_merchant_listings_all_data)TEXTzshop-storefront-feature (get_merchant_listings_all_data) This is used; for backwards compatibility only.;
MonthTEXTNumber of the month
Alert (get_restock_inventory_recommendations_report)TEXTAlert (get_restock_inventory_recommendations_report)
ASIN (get_restock_inventory_recommendations_report)TEXTASIN (get_restock_inventory_recommendations_report)
Available (get_restock_inventory_recommendations_report)NUMERICAvailable (get_restock_inventory_recommendations_report)
Condition (get_restock_inventory_recommendations_report)TEXTCondition (get_restock_inventory_recommendations_report)
Country (get_restock_inventory_recommendations_report)COUNTRYCountry (get_restock_inventory_recommendations_report)
Currency code (get_restock_inventory_recommendations_report)TEXTCurrency code (get_restock_inventory_recommendations_report)
Customer Order (get_restock_inventory_recommendations_report)NUMERICCustomer Order (get_restock_inventory_recommendations_report);
Days of Supply at Amazon Fulfillment Network (get_restock_inventory_recommendations_report)TEXTDays of Supply at Amazon Fulfillment Network; (get_restock_inventory_recommendations_report);
FC Processing (get_restock_inventory_recommendations_report)NUMERICFC Processing (get_restock_inventory_recommendations_report)
FC transfer (get_restock_inventory_recommendations_report)NUMERICFC transfer (get_restock_inventory_recommendations_report)
FNSKU (get_restock_inventory_recommendations_report)TEXTFNSKU (get_restock_inventory_recommendations_report)
Fulfilled by (get_restock_inventory_recommendations_report)TEXTFulfilled by (get_restock_inventory_recommendations_report)
Inbound (get_restock_inventory_recommendations_report)NUMERICInbound (get_restock_inventory_recommendations_report)
Merchant SKU (get_restock_inventory_recommendations_report)TEXTMerchant SKU (get_restock_inventory_recommendations_report)
Price (get_restock_inventory_recommendations_report)NUMERICPrice (get_restock_inventory_recommendations_report)
Product Name (get_restock_inventory_recommendations_report)TEXTProduct Name (get_restock_inventory_recommendations_report)
Receiving (get_restock_inventory_recommendations_report)NUMERICReceiving (get_restock_inventory_recommendations_report)
TEXTRecommended action (get_restock_inventory_recommendations_report);
NUMERICRecommended replenishment qty; (get_restock_inventory_recommendations_report);
DATERecommended ship date (get_restock_inventory_recommendations_report);
Sales last 30 days (get_restock_inventory_recommendations_report)NUMERICSales last 30 days (get_restock_inventory_recommendations_report);
Shipped (get_restock_inventory_recommendations_report)NUMERICShipped (get_restock_inventory_recommendations_report)
Supplier (get_restock_inventory_recommendations_report)TEXTSupplier (get_restock_inventory_recommendations_report)
Supplier part no. (get_restock_inventory_recommendations_report)TEXTSupplier part no. (get_restock_inventory_recommendations_report);
Total Days of Supply (including units from open shipments) (get_restock_inventory_recommendations_report)TEXTTotal Days of Supply (including units from open shipments); (get_restock_inventory_recommendations_report);
Total Units (get_restock_inventory_recommendations_report)NUMERICTotal Units (get_restock_inventory_recommendations_report)
Unfulfillable (get_restock_inventory_recommendations_report)NUMERICUnfulfillable (get_restock_inventory_recommendations_report)
Units Sold Last 30 Days (get_restock_inventory_recommendations_report)NUMERICUnits Sold Last 30 Days (get_restock_inventory_recommendations_report);
Working (get_restock_inventory_recommendations_report)NUMERICWorking (get_restock_inventory_recommendations_report)
childAsin (get_sales_and_traffic_report)TEXTchildAsin (get_sales_and_traffic_report)
date (get_sales_and_traffic_report)DATEdate (get_sales_and_traffic_report)
parentAsin (get_sales_and_traffic_report)TEXTparentAsin (get_sales_and_traffic_report)
salesByAsin-averageSalesPerOrderItem-amount (get_sales_and_traffic_report)NUMERICsalesByAsin-averageSalesPerOrderItem-amount (get_sales_and_traffic_report)
salesByAsin-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report)TEXTsalesByAsin-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report)
salesByAsin-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report)NUMERICsalesByAsin-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report)
salesByAsin-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report)TEXTsalesByAsin-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report)
salesByAsin-averageSellingPrice-amount (get_sales_and_traffic_report)NUMERICsalesByAsin-averageSellingPrice-amount (get_sales_and_traffic_report)
salesByAsin-averageSellingPrice-currencyCode (get_sales_and_traffic_report)TEXTsalesByAsin-averageSellingPrice-currencyCode (get_sales_and_traffic_report)
salesByAsin-averageSellingPriceB2B-amount (get_sales_and_traffic_report)NUMERICsalesByAsin-averageSellingPriceB2B-amount (get_sales_and_traffic_report)
salesByAsin-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report)TEXTsalesByAsin-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report)
salesByAsin-averageUnitsPerOrderItem (get_sales_and_traffic_report)NUMERICsalesByAsin-averageUnitsPerOrderItem (get_sales_and_traffic_report)
salesByAsin-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report)NUMERICsalesByAsin-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report)
salesByAsin-claimsAmount-amount (get_sales_and_traffic_report)TEXTsalesByAsin-claimsAmount-amount (get_sales_and_traffic_report)
salesByAsin-claimsAmount-currencyCode (get_sales_and_traffic_report)TEXTsalesByAsin-claimsAmount-currencyCode (get_sales_and_traffic_report)
salesByAsin-claimsGranted (get_sales_and_traffic_report)TEXTsalesByAsin-claimsGranted (get_sales_and_traffic_report)
salesByAsin-orderedProductSales-amount (get_sales_and_traffic_report)NUMERICsalesByAsin-orderedProductSales-amount (get_sales_and_traffic_report)
salesByAsin-orderedProductSales-currencyCode (get_sales_and_traffic_report)TEXTsalesByAsin-orderedProductSales-currencyCode (get_sales_and_traffic_report)
salesByAsin-orderedProductSalesB2B-amount (get_sales_and_traffic_report)NUMERICsalesByAsin-orderedProductSalesB2B-amount (get_sales_and_traffic_report)
salesByAsin-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report)TEXTsalesByAsin-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report)
salesByAsin-ordersShipped (get_sales_and_traffic_report)NUMERICsalesByAsin-ordersShipped (get_sales_and_traffic_report)
salesByAsin-refundRate (get_sales_and_traffic_report)NUMERICsalesByAsin-refundRate (get_sales_and_traffic_report)
salesByAsin-shippedProductSales-amount (get_sales_and_traffic_report)NUMERICsalesByAsin-shippedProductSales-amount (get_sales_and_traffic_report)
salesByAsin-shippedProductSales-currencyCode (get_sales_and_traffic_report)TEXTsalesByAsin-shippedProductSales-currencyCode (get_sales_and_traffic_report)
salesByAsin-totalOrderItems (get_sales_and_traffic_report)NUMERICsalesByAsin-totalOrderItems (get_sales_and_traffic_report)
salesByAsin-totalOrderItemsB2B (get_sales_and_traffic_report)NUMERICsalesByAsin-totalOrderItemsB2B (get_sales_and_traffic_report)
salesByAsin-unitsOrdered (get_sales_and_traffic_report)NUMERICsalesByAsin-unitsOrdered (get_sales_and_traffic_report)
salesByAsin-unitsOrderedB2B (get_sales_and_traffic_report)NUMERICsalesByAsin-unitsOrderedB2B (get_sales_and_traffic_report)
salesByAsin-unitsRefunded (get_sales_and_traffic_report)NUMERICsalesByAsin-unitsRefunded (get_sales_and_traffic_report)
salesByAsin-unitsShipped (get_sales_and_traffic_report)NUMERICsalesByAsin-unitsShipped (get_sales_and_traffic_report)
salesByDate-averageSalesPerOrderItem-amount (get_sales_and_traffic_report)NUMERICsalesByDate-averageSalesPerOrderItem-amount (get_sales_and_traffic_report)
salesByDate-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report)TEXTsalesByDate-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report)
salesByDate-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report)NUMERICsalesByDate-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report)
salesByDate-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report)TEXTsalesByDate-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report)
salesByDate-averageSellingPrice-amount (get_sales_and_traffic_report)NUMERICsalesByDate-averageSellingPrice-amount (get_sales_and_traffic_report)
salesByDate-averageSellingPrice-currencyCode (get_sales_and_traffic_report)TEXTsalesByDate-averageSellingPrice-currencyCode (get_sales_and_traffic_report)
salesByDate-averageSellingPriceB2B-amount (get_sales_and_traffic_report)NUMERICsalesByDate-averageSellingPriceB2B-amount (get_sales_and_traffic_report)
salesByDate-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report)TEXTsalesByDate-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report)
salesByDate-averageUnitsPerOrderItem (get_sales_and_traffic_report)NUMERICsalesByDate-averageUnitsPerOrderItem (get_sales_and_traffic_report)
salesByDate-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report)NUMERICsalesByDate-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report)
salesByDate-claimsAmount-amount (get_sales_and_traffic_report)TEXTsalesByDate-claimsAmount-amount (get_sales_and_traffic_report)
salesByDate-claimsAmount-currencyCode (get_sales_and_traffic_report)TEXTsalesByDate-claimsAmount-currencyCode (get_sales_and_traffic_report)
salesByDate-claimsGranted (get_sales_and_traffic_report)TEXTsalesByDate-claimsGranted (get_sales_and_traffic_report)
salesByDate-orderedProductSales-amount (get_sales_and_traffic_report)NUMERICsalesByDate-orderedProductSales-amount (get_sales_and_traffic_report)
salesByDate-orderedProductSales-currencyCode (get_sales_and_traffic_report)TEXTsalesByDate-orderedProductSales-currencyCode (get_sales_and_traffic_report)
salesByDate-orderedProductSalesB2B-amount (get_sales_and_traffic_report)NUMERICsalesByDate-orderedProductSalesB2B-amount (get_sales_and_traffic_report)
salesByDate-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report)TEXTsalesByDate-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report)
salesByDate-ordersShipped (get_sales_and_traffic_report)NUMERICsalesByDate-ordersShipped (get_sales_and_traffic_report)
salesByDate-refundRate (get_sales_and_traffic_report)NUMERICsalesByDate-refundRate (get_sales_and_traffic_report)
salesByDate-shippedProductSales-amount (get_sales_and_traffic_report)NUMERICsalesByDate-shippedProductSales-amount (get_sales_and_traffic_report)
salesByDate-shippedProductSales-currencyCode (get_sales_and_traffic_report)TEXTsalesByDate-shippedProductSales-currencyCode (get_sales_and_traffic_report)
salesByDate-totalOrderItems (get_sales_and_traffic_report)NUMERICsalesByDate-totalOrderItems (get_sales_and_traffic_report)
salesByDate-totalOrderItemsB2B (get_sales_and_traffic_report)NUMERICsalesByDate-totalOrderItemsB2B (get_sales_and_traffic_report)
salesByDate-unitsOrdered (get_sales_and_traffic_report)NUMERICsalesByDate-unitsOrdered (get_sales_and_traffic_report)
salesByDate-unitsOrderedB2B (get_sales_and_traffic_report)NUMERICsalesByDate-unitsOrderedB2B (get_sales_and_traffic_report)
salesByDate-unitsRefunded (get_sales_and_traffic_report)NUMERICsalesByDate-unitsRefunded (get_sales_and_traffic_report)
salesByDate-unitsShipped (get_sales_and_traffic_report)NUMERICsalesByDate-unitsShipped (get_sales_and_traffic_report)
trafficByAsin-averageOfferCount (get_sales_and_traffic_report)NUMERICtrafficByAsin-averageOfferCount (get_sales_and_traffic_report)
trafficByAsin-averageParentItems (get_sales_and_traffic_report)NUMERICtrafficByAsin-averageParentItems (get_sales_and_traffic_report)
trafficByAsin-browserPageViews (get_sales_and_traffic_report)NUMERICtrafficByAsin-browserPageViews (get_sales_and_traffic_report)
trafficByAsin-browserPageViewsB2B (get_sales_and_traffic_report)NUMERICtrafficByAsin-browserPageViewsB2B (get_sales_and_traffic_report)
trafficByAsin-browserSessions (get_sales_and_traffic_report)NUMERICtrafficByAsin-browserSessions (get_sales_and_traffic_report)
trafficByAsin-browserSessionsB2B (get_sales_and_traffic_report)NUMERICtrafficByAsin-browserSessionsB2B (get_sales_and_traffic_report)
trafficByAsin-buyBoxPercentage (get_sales_and_traffic_report)NUMERICtrafficByAsin-buyBoxPercentage (get_sales_and_traffic_report)
trafficByAsin-buyBoxPercentageB2B (get_sales_and_traffic_report)NUMERICtrafficByAsin-buyBoxPercentageB2B (get_sales_and_traffic_report)
trafficByAsin-feedbackReceived (get_sales_and_traffic_report)TEXTtrafficByAsin-feedbackReceived (get_sales_and_traffic_report)
trafficByAsin-mobileAppPageViews (get_sales_and_traffic_report)NUMERICtrafficByAsin-mobileAppPageViews (get_sales_and_traffic_report)
trafficByAsin-mobileAppPageViewsB2B (get_sales_and_traffic_report)NUMERICtrafficByAsin-mobileAppPageViewsB2B (get_sales_and_traffic_report)
trafficByAsin-mobileAppSessions (get_sales_and_traffic_report)NUMERICtrafficByAsin-mobileAppSessions (get_sales_and_traffic_report)
trafficByAsin-mobileAppSessionsB2B (get_sales_and_traffic_report)NUMERICtrafficByAsin-mobileAppSessionsB2B (get_sales_and_traffic_report)
trafficByAsin-negativeFeedbackReceived (get_sales_and_traffic_report)TEXTtrafficByAsin-negativeFeedbackReceived (get_sales_and_traffic_report)
trafficByAsin-orderItemSessionPercentage (get_sales_and_traffic_report)NUMERICtrafficByAsin-orderItemSessionPercentage (get_sales_and_traffic_report)
trafficByAsin-orderItemSessionPercentageB2B (get_sales_and_traffic_report)NUMERICtrafficByAsin-orderItemSessionPercentageB2B (get_sales_and_traffic_report)
trafficByAsin-pageViews (get_sales_and_traffic_report)NUMERICtrafficByAsin-pageViews (get_sales_and_traffic_report)
trafficByAsin-pageViewsB2B (get_sales_and_traffic_report)NUMERICtrafficByAsin-pageViewsB2B (get_sales_and_traffic_report)
trafficByAsin-receivedNegativeFeedbackRate (get_sales_and_traffic_report)TEXTtrafficByAsin-receivedNegativeFeedbackRate (get_sales_and_traffic_report)
trafficByAsin-sessions (get_sales_and_traffic_report)NUMERICtrafficByAsin-sessions (get_sales_and_traffic_report)
trafficByAsin-sessionsB2B (get_sales_and_traffic_report)NUMERICtrafficByAsin-sessionsB2B (get_sales_and_traffic_report)
trafficByAsin-unitSessionPercentage (get_sales_and_traffic_report)NUMERICtrafficByAsin-unitSessionPercentage (get_sales_and_traffic_report)
trafficByAsin-unitSessionPercentageB2B (get_sales_and_traffic_report)NUMERICtrafficByAsin-unitSessionPercentageB2B (get_sales_and_traffic_report)
trafficByDate-averageOfferCount (get_sales_and_traffic_report)NUMERICtrafficByDate-averageOfferCount (get_sales_and_traffic_report)
trafficByDate-averageParentItems (get_sales_and_traffic_report)NUMERICtrafficByDate-averageParentItems (get_sales_and_traffic_report)
trafficByDate-browserPageViews (get_sales_and_traffic_report)NUMERICtrafficByDate-browserPageViews (get_sales_and_traffic_report)
trafficByDate-browserPageViewsB2B (get_sales_and_traffic_report)NUMERICtrafficByDate-browserPageViewsB2B (get_sales_and_traffic_report)
trafficByDate-browserSessions (get_sales_and_traffic_report)NUMERICtrafficByDate-browserSessions (get_sales_and_traffic_report)
trafficByDate-browserSessionsB2B (get_sales_and_traffic_report)NUMERICtrafficByDate-browserSessionsB2B (get_sales_and_traffic_report)
trafficByDate-buyBoxPercentage (get_sales_and_traffic_report)NUMERICtrafficByDate-buyBoxPercentage (get_sales_and_traffic_report)
trafficByDate-buyBoxPercentageB2B (get_sales_and_traffic_report)NUMERICtrafficByDate-buyBoxPercentageB2B (get_sales_and_traffic_report)
trafficByDate-feedbackReceived (get_sales_and_traffic_report)TEXTtrafficByDate-feedbackReceived (get_sales_and_traffic_report)
trafficByDate-mobileAppPageViews (get_sales_and_traffic_report)NUMERICtrafficByDate-mobileAppPageViews (get_sales_and_traffic_report)
trafficByDate-mobileAppPageViewsB2B (get_sales_and_traffic_report)NUMERICtrafficByDate-mobileAppPageViewsB2B (get_sales_and_traffic_report)
trafficByDate-mobileAppSessions (get_sales_and_traffic_report)NUMERICtrafficByDate-mobileAppSessions (get_sales_and_traffic_report)
trafficByDate-mobileAppSessionsB2B (get_sales_and_traffic_report)NUMERICtrafficByDate-mobileAppSessionsB2B (get_sales_and_traffic_report);
trafficByDate-negativeFeedbackReceived (get_sales_and_traffic_report)TEXTtrafficByDate-negativeFeedbackReceived (get_sales_and_traffic_report)
trafficByDate-orderItemSessionPercentage (get_sales_and_traffic_report)NUMERICtrafficByDate-orderItemSessionPercentage (get_sales_and_traffic_report)
trafficByDate-orderItemSessionPercentageB2B (get_sales_and_traffic_report)NUMERICtrafficByDate-orderItemSessionPercentageB2B (get_sales_and_traffic_report)
trafficByDate-pageViews (get_sales_and_traffic_report)NUMERICtrafficByDate-pageViews (get_sales_and_traffic_report)
trafficByDate-pageViewsB2B (get_sales_and_traffic_report)NUMERICtrafficByDate-pageViewsB2B (get_sales_and_traffic_report)
trafficByDate-receivedNegativeFeedbackRate (get_sales_and_traffic_report)TEXTtrafficByDate-receivedNegativeFeedbackRate (get_sales_and_traffic_report)
trafficByDate-sessions (get_sales_and_traffic_report)NUMERICtrafficByDate-sessions (get_sales_and_traffic_report)
trafficByDate-sessionsB2B (get_sales_and_traffic_report)NUMERICtrafficByDate-sessionsB2B (get_sales_and_traffic_report)
trafficByDate-unitSessionPercentage (get_sales_and_traffic_report)NUMERICtrafficByDate-unitSessionPercentage (get_sales_and_traffic_report)
trafficByDate-unitSessionPercentageB2B (get_sales_and_traffic_report)NUMERICtrafficByDate-unitSessionPercentageB2B (get_sales_and_traffic_report)
SourceTEXTThe name of the Windsor connector returning the row
TodayDATEToday's date
adjustment-id (get_v2_settlement_report_data_flat_file_v2)TEXTadjustment-id (get_v2_settlement_report_data_flat_file_v2)
amount (get_v2_settlement_report_data_flat_file_v2)NUMERICamount (get_v2_settlement_report_data_flat_file_v2)
amount-description (get_v2_settlement_report_data_flat_file_v2)TEXTamount-description (get_v2_settlement_report_data_flat_file_v2);
amount-type (get_v2_settlement_report_data_flat_file_v2)TEXTamount-type (get_v2_settlement_report_data_flat_file_v2)
currency (get_v2_settlement_report_data_flat_file_v2)TEXTcurrency (get_v2_settlement_report_data_flat_file_v2)
deposit-date (get_v2_settlement_report_data_flat_file_v2)DATEdeposit-date (get_v2_settlement_report_data_flat_file_v2)
fulfillment-id (get_v2_settlement_report_data_flat_file_v2)TEXTfulfillment-id (get_v2_settlement_report_data_flat_file_v2)
marketplace-name (get_v2_settlement_report_data_flat_file_v2)TEXTmarketplace-name (get_v2_settlement_report_data_flat_file_v2);
merchant-adjustment-item-id (get_v2_settlement_report_data_flat_file_v2)TEXTmerchant-adjustment-item-id; (get_v2_settlement_report_data_flat_file_v2);
merchant-order-id (get_v2_settlement_report_data_flat_file_v2)TEXTmerchant-order-id (get_v2_settlement_report_data_flat_file_v2);
merchant-order-item-id (get_v2_settlement_report_data_flat_file_v2)TEXTmerchant-order-item-id (get_v2_settlement_report_data_flat_file_v2);
order-id (get_v2_settlement_report_data_flat_file_v2)TEXTorder-id (get_v2_settlement_report_data_flat_file_v2)
order-item-code (get_v2_settlement_report_data_flat_file_v2)TEXTorder-item-code (get_v2_settlement_report_data_flat_file_v2)
posted-date (get_v2_settlement_report_data_flat_file_v2)DATEposted-date (get_v2_settlement_report_data_flat_file_v2)
posted-date-time (get_v2_settlement_report_data_flat_file_v2)TEXTposted-date-time (get_v2_settlement_report_data_flat_file_v2);
promotion-id (get_v2_settlement_report_data_flat_file_v2)TEXTpromotion-id (get_v2_settlement_report_data_flat_file_v2)
quantity-purchased (get_v2_settlement_report_data_flat_file_v2)NUMERICquantity-purchased (get_v2_settlement_report_data_flat_file_v2);
settlement-end-date (get_v2_settlement_report_data_flat_file_v2)DATEsettlement-end-date (get_v2_settlement_report_data_flat_file_v2);
settlement-id (get_v2_settlement_report_data_flat_file_v2)TEXTsettlement-id (get_v2_settlement_report_data_flat_file_v2)
settlement-start-date (get_v2_settlement_report_data_flat_file_v2)DATEsettlement-start-date (get_v2_settlement_report_data_flat_file_v2);
shipment-id (get_v2_settlement_report_data_flat_file_v2)TEXTshipment-id (get_v2_settlement_report_data_flat_file_v2)
sku (get_v2_settlement_report_data_flat_file_v2)TEXTsku (get_v2_settlement_report_data_flat_file_v2)
total-amount (get_v2_settlement_report_data_flat_file_v2)NUMERICtotal-amount (get_v2_settlement_report_data_flat_file_v2)
transaction-type (get_v2_settlement_report_data_flat_file_v2)TEXTtransaction-type (get_v2_settlement_report_data_flat_file_v2);
WeekTEXTWeek (Sun-Sat).
Day of week and day numberTEXTWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
Day of week and day number, ISOTEXTWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
Week ISOTEXTWeek, ISO format (Mon-Sun).
YearTEXTYear
YearmonthTEXTYear and month, e.g. 2024|3
Year of weekTEXTThe year that contains first day of the week (Sun-Sat).
Year of week, ISOTEXTThe year that contains first day of the ISO week (Mon-Sun).
Year weekTEXTYear and week for US weeks (Sun-Sat), e.g. 2024|15
Year week ISOTEXTYear and week for ISO weeks (Mon-Sun), e.g. 2024|20

Easily connect Amazon Seller Central to Azure SQL

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your Amazon Seller Central and Azure SQL Integrations

Facebook Ads Azure SQL Integration