View source

From MediaSell

for Term:Amazon fulfillment report file format

You do not have permission to do that, for the following reason:

The action you have requested is limited to users in the group fillzapproved.

You can view and copy the source of this page:

{|  style="background:#616D7E" align="center"  cellspacing="1" cellpadding ="4"
|  align="center" bgcolor="#AADD00"|<font color="white"><big><b>Amazon Fulfillment Report File Format</b></big></font>
|-
| bgcolor="#F5F5F5"|

''<font color=navy>The Amazon fulfillment report file format includes the columns listed below. </font>''


Columns should be:
*separated with tabs
*should follow the [[wikipedia:Comma-separated_values|CSV]] convention
*should '''not''' contain extra spaces before or after header names


'''Note:''' Columns in '''<font color=green>GREEN</font>''' are required.

{|  style="background:#616D7E" align="left"  cellspacing="1" cellpadding ="4"
| bgcolor="#1021B9"|<font color=white>'''Header'''</font>
| bgcolor="#1021B9"|<font color=white>'''Data'''</font>
|-
| bgcolor="#EDEDED"|<font color=green>'''payment-status''' </font>
| bgcolor="#F5F5F5"|should have a value of paid_ship_now for the order to be picked up
|-
| bgcolor="#EDEDED"|<font color=green>'''order-id'''</font>
| bgcolor="#F5F5F5"|unique numeric ID for the order on FillZ. If an order has multiple line items, there will be multiple records with the same ID and they will appear contiguously in the file
|-
| bgcolor="#EDEDED"|'''order-item_id'''
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|<font color=green>'''payments-date'''</font>
| bgcolor="#F5F5F5"|date the customer paid for the order <font color=red>Date Format: yyyy-mm-dd hh:mm:ss</font> ('''Example:''' 2007-05-24 13:32:15)
|-
| bgcolor="#EDEDED"|'''payments-transaction-id''' 
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|'''product-id'''
| bgcolor="#F5F5F5"|ISBN/UPC/ASIN/EAN
|-
| bgcolor="#EDEDED"|<font color=green>'''item-name'''</font>
| bgcolor="#F5F5F5"|title of item
|-
| bgcolor="#EDEDED"|'''listing-id''' 
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|<font color=green>'''sku'''</font>
| bgcolor="#F5F5F5"|this is the only field you should use to match your internal database
|-
| bgcolor="#EDEDED"|<font color=green>'''price'''</font>
| bgcolor="#F5F5F5"|this field is reliable for all markets, but it is only the customer facing amount, without any deductions for fees. It should be multiplied by the "quantity_purchased" field for a sub-total
|-
| bgcolor="#EDEDED"| '''shipping-fee'''
| bgcolor="#F5F5F5"|only reliable for Amazon and Biblio
|-
| bgcolor="#EDEDED"|<font color=green>'''quantity-purchased'''</font>
| bgcolor="#F5F5F5"|indicates how many items should be shipped
|-
| bgcolor="#EDEDED"|'''total-price'''
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|<font color=green>'''purchase-date'''</font>
| bgcolor="#F5F5F5"|date the order was placed
|-
| bgcolor="#EDEDED"|'''batch-id''' 
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|<font color=green>'''buyer-email''' </font>
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|<font color=green>'''buyer-name''' </font>
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|<font color=green>'''recipient-name'''</font>
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|<font color=green>'''ship-address-1'''</font>
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|'''ship-address-2''' 
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|<font color=green>'''ship-city'''</font>
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|<font color=green>'''ship-state'''</font>
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|<font color=green>'''ship-zip'''</font>
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|<font color=green>'''ship-country'''</font>
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|'''special-comments'''
| bgcolor="#F5F5F5"|this field will contain the marketplace name followed by a slash (/) and the marketplace order identifier
|-
| bgcolor="#EDEDED"|'''upc'''
| bgcolor="#F5F5F5"|this field will be filled in for non-book items
|-
| bgcolor="#EDEDED"|<font color=green>'''ship-method'''</font>
| bgcolor="#F5F5F5"|If "Standard" appears anywhere in this field, regardless of case (upper/lower), you should ship using your "slow" method. If "Standard" does not appear, you should ship using a "fast" method. Other text in the field is informational only and should not be used to make shipping method decisions
|-
| bgcolor="#EDEDED"| '''status''' 
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|'''location'''  
| bgcolor="#F5F5F5"|
|-
| bgcolor="#EDEDED"|'''tracking'''  
| bgcolor="#F5F5F5"|
|}
|}

Return to Term:Amazon fulfillment report file format.

Retrieved from "http://wiki.fillz.com/wiki/index.php/Term:Amazon_fulfillment_report_file_format"

View source

From MediaSell

Views

Personal tools

Welcome to FillZ Wiki

Marketplaces

Other

Wiki Tools

Search

Toolbox