Estimated sales report generation through Amazon API (MWS – Marketplace API)

What is MWS MWS (MarketPlace Web Service) is a specific service for people who sell on Amazon.com. I

Software outsourcing companies India

What is MWS?

MWS (MarketPlace Web Service) is a specific service for people who sell on Amazon.com. It provides sellers with an API through which they can access their Amazon account from within their own computing systems.

The Amazon Marketplace Web Service (Amazon MWS) Fulfilment API sections include operations that allow sellers to access Amazon’s services through a simple web service interface and can build innovative web or desktop software for better analysis and decision making taking help of custom software companies.

MWS helps sellers to automate orders, listings, reports, payments and many more features. Seller can integrate Amazon marketplace into their current applications and workflow by exchanging data.

For everyone Amazon storefront enabled with MWS, there are 4 different keys that tell Amazon exactly which store you’re uploading data to. These are :

  • AccessKeyId
  • SecretAccessKeyId
  • MerchantId
  • MarketplaceId

What is Estimated Sales Report?

Estimated Sales Report is used for getting the list of items that are sold on amazon even though there settlement report are not yet generated. The settlement report is generated after 15 days so it is not possible to calculate profit/loss real time. Estimated Sales Report comes to rescue here. It helps to generate sales report real time.

Process for using Amazon API to generate Estimated Sales Report

  • First step is to call ReportRequest method from MWS. Start_Date and End_Date are passed as parameter. Default value is current date and time. This returns the data from where the last settlement report was generated. This method will return the ReportRequestId List.
  • Second step is to call the GetReportRequestList method recursively until the ReportRequestId field has status “_DONE_”. When we get the matched status for the ReportRequestId, it returns the List of GeneratedReportId.
  • Check that the GeneratedReportId is present in our system to avoid duplicate entry and use GetReportRequest method to generate the report. If the GeneratedReportId is not present in the system we use the GetReportRequest and we  pass GeneratedReportId as the parameter. It returns data in XML format.
  • Deserialize the output to get desired output. Use that data and save it in the system. Developers allow this function to run automatically every hour to receive latest data regularly. Profit/loss report thus generated is more accurate and latest.
  • The Estimate sales report includes recent orders regardless of whether they have been shipped. Estimated sales report provides important information like amazon order id, the selling price, Amazon service charges, title of the item, ASIN of the item, status of the item (i.e shipped, unshipped, cancelled or pending), the date and time of the item sold and the sellerSku of the item. SellerSku provides information on which customer has scanned the item for selling the item to the amazon.

Process flow diagram

Conclusion

Estimated sales report provides very important information about items that are sold through Amazon regularly. This provides analytical information for better decision making and provides these information real time making it very useful to sellers. Real time profit/loss information, customer information, sales information becomes handy.

 

Managing shipment process using Amazon API (MWS – Marketplace Web Service)

Are you managing online store and wondering how Amazon API can help software development companies t

Software outsourcing companies India

 

Are you managing online store and wondering how Amazon API can help software development companies to manage shipment process? Amazon provides Marketplace Web Service that can assist you managing shipment process in your web application or portal programmatically.

Diagram depicts the complete shipment process from creating a listing through downloading the labels using MWS.

Step 1 - Create a listing

Before sending an item to the Amazon Fulfillment Network (AFN), programmer needs to create a listing in Amazon's catalog. This is true regardless of whether or not one intends to sell on Amazon's web site or through other sales channels. It is mandatory to mark items as AFN i.e. Amazon Fulfillment Network that tags an item to be fulfilled by Amazon. SubmitFeed operation of the Feeds API is used to mark an item as AFN.

 Step 2 – Create an inbound shipment plan

CreateInboundShipmentPlan operation of the Inbound Shipment API is used to create an inbound shipment plan. An inbound shipment plan groups into discrete shipments the items to be sent to the Amazon Fulfillment Network.

By submitting the CreateInboundShipmentPlan operation, Amazon is provided with key information about the items to be sent. In this operation list of sellerSku, quantity, ASIN, condition of the item and the from-address are sent.

Amazon uses this information to create a shipment plan for items, which is returned after Amazon receives the CreateInboundShipmentPlan operation. Programmer uses the shipment plan to group and send items to the appropriate Amazon fulfillment centers. As an output it will return the to-address for the shipment, FCCD, the shipmentId, the FnskuName of the item and the quantity of the item to ship.

Step 3 – Create / Update inbound shipment

For each shipment returned by the CreateInboundShipmentPlan operation, create an inbound shipment. An inbound shipment is created by submitting the CreateInboundShipment / UpdateInboundShipment operation of the Inbound Shipment API section.

 One should check for the to-address given by inbound shipment plan, to check for any active shipment on the same address. If the active shipment is not present then the CreateInboundShipment operation is used and if the active shipment is there, then the UpdateInboundShipment operation is used.

The shipmentId, FCCD, to-address generated by inbound shipment plan, and also the list of sellerSku and the quantity of each sellerSku as passed to Amazon API.  On inbound shipment creation/updation, indicates to Amazon are created to denote arrival of items to AFC (Amazon fulfillment center).

Step 4 – Transport Shipment

Before sending the shipment in the transport state, developer needs to specify the shipment box weight, height, width and length and then we can mark the shipment in the transport state. Here we need to keep in mind that the weight and dimension of the box specified must be correct, if there is difference then the shipment will we canceled and if this type of mistake occurs frequently then your account might be blocked by the amazon.

Step 5 – Estimating Shipment

When the shipment is successfully transported then the next step is to estimate the shipment, means to calculate the cost of the shipment based on the weight and the dimension of the shipment box. For calculating the shipment cost GetTransportContent operation is used.

Step 6 – Confirm Estimate Shipment Cost

User decides whether calculated cost is feasible for him or not. If the user confirms the cost, the shipment is marked as shipped and the user needs to pay to the Amazon. If the user cancels, shipment is not shipped and stays in the estimated status and user needs to pay that shipment until he confirms the shipment cost.

Step 7 – Download Shipment Label

Use the GetUniquePackageLabel operation to request unique shipping labels for your inbound shipments. This option is active once shipment is confirmed. User receives PDF file with all details regarding shipment.  Download shipment label option is available for each shipment created by User on confirmation. User can also download this shipment label even after a week or month of his shipment process. This helps to ensure that the shipment is processed at the Amazon fulfillment center quickly and accurately.