Amazon MWS FeedSubmissionID type?

When submitting a feed via Amazon MWS API it returns a feed submission ID which is typed as string, while all the figures it returns seem to be of type int.

Question: is there a reason they have it as string and is it safe to always convert this value to int (I mean may I be sure they won't add a letter to that ID like "123abc").

Reason for the question: how to store the value in the database: char(), varchar() or int? I suppose we can expect this ID to have more length eventually, since the ID is incremented. Thus char() won't work. Next, varchar(how_long?) - currently the ID is 10 chars long - add some extra room to it (say varchar(15))? Or maybe just use int - will be faster in search and accommodate the ID until it grows to a bigint (if ever), or just make it bigint and final?

This is the dilemma.

-------------Problems Reply------------

is there a reason they have it as string and is it safe to always convert this value to int

I would not convert this value to an int unless you plan on using it mathematically.

(I mean may I be sure they won't add a letter to that ID like "123abc").

You can never be sure of this. This is an identifier and it is completely possible that they will start adding non-numeric characters to it in the future.

I am not a database expert so I can not really advise you as to what the best types are for certain scenarios. One thing that will hold true is that you will not be able to tell which is faster or more efficient until you benchmark your application.

My recommendation is to store the value as a varchar(25) which will give you plenty of space for the future. I would also advise you to focus more on the maintainability of your application than on the performance or efficiency.

Category:sql Views:1 Time:2012-01-26
Tags: sql amazon mws

Related post

  • Lookup item by ASIN with Amazon MWS? 2011-07-13

    I am using Amazon MWS and XML Feeds API (unfortunately I think you need a seller account to view these links) I need to get a list of all the items we sell on Amazon (to cross reference product names across our other selling channels). So technically

  • How to switch to Amazon MWS from AIM? 2011-11-03

    I recently discovered that Amazon will be gradually shifting to their MWS system soon, and that if I want to incorporate all of our European Amazon accounts into one marketplace, I will need to be using MWS to upload our store inventory to the accoun

  • Python library for Amazon MWS 2010-10-05

    Is there a Python library for interacting with Amazon MWS? I found Ruby, Perl, PHP, C#, and Java versions, but not Python. --------------Solutions------------- didn't find one so developed my own basic version:

  • Sequence constraints of product feeds for Amazon MWS 2011-08-26

    I am currently working on a specification for a software component which will synchronize the product catalog of an ecommerce company with the Amazon Marketplace using Amazon MWS. According to the MWS developer documentation, publishing products requ

  • Where are the specifications/XSDs for Amazon MWS feed XML processing reports? 2012-01-19

    Amazon provides a batch of documents describing the format of the feeds we can send via MWS, however, we also need to know what to expect in their responses, what status codes may be reported or what is the structure of XML when errors reported, etc.

  • How to upload/publish products to Amazon via Amazon MWS API? 2012-02-03

    I heard SubmitFeed API is for adding products. But i didn't find any example. By the way, i need a Python solution. Thanks a lot. --------------Solutions------------- The general gist of it is you use SubmitFeed to send your product list. Then you mu

  • Amazon MWS API PHP Samples return internal server error 500 2013-12-29

    I have been trying to use a sample from Amazon MWS API but whatever I do I always get blank page with error 500. I have setup the IDs correctly. cURL is up and running The server has correct SSL certificates (I tried the samples on two different serv

  • Amazon MWS problem with _POST_INVENTORY_AVAILABILITY_DATA_ 2011-03-31

    im using the "C# Library for Batch Data Exchange Feeds" from I want to update the quantity of a product, I get a repsonse with "SUBMITTED" and the function "GetFeedSubmissionResult" ret

  • Amazon MWS - request signature calculated does not match the signature provided 2010-05-05

    Getting the following error message from <Type>Sender</Type> <Code>SignatureDoesNotMatch</Code> − <Message> The request signature we calculated does not match the signature you provided.

  • getting error 13043 when trying to submit product feed to amazon mws 2012-05-02

    Hi i am using the mws for sending product feed to amazon. this is what i am sending, in the product feed, not the price feed using type of: _POST_PRODUCT_DATA_ why i get error syaing my price is not good? <?xml version="1.0" encoding="utf-8"?>

  • Amazon MWS - Is it possible to reduce the order quantity using the OrderAdjustment feed 2010-06-30

    When I send an Order Adjustment feed such as <MessageType>OrderAdjustment</MessageType> <Message> <MessageID>1</MessageID> <OrderAdjustment> <AmazonOrderID>104-3121897-1466636</AmazonOrderID> <Adjust

  • Amazon MWS Flat File Modify Listing 2011-07-23

    I'm trying to find the documentation for how the flat file looks for modifying the quantity of a product on Amazon. This is what we send at the moment but it would be good to see what the list of headings we can use. SKU | Quantity 000 | 1 I'm guessi

  • Does Amazon MWS Throtlling means you can update 15 records or execute 15 update API calls? 2011-08-21

    I posted this question on MWS forum but, didn't get an answer. So, I'm posting this here hoping for an answer. Here goes: Hi, I'm an absolute newbie in to MWS and I'm trying to understand the throttling impact on my design. Taking an example of Submi

  • Amazon MWS Products SignatureDoesNotMatch 2014-07-24

    When I run this code, I get a SignatureDoesNotMatch error. I'm not finding the issue. I even commented out the sort() to keep the array in natural order. Any help would be appreciated. $params = array( 'AWSAccessKeyId' => "*********", 'Action' =

  • How to get shipping costs of an order with Amazon MWS Api? 2012-03-22

    I would like to get shipping costs of an order. I can get amount, customer information, purchase date of an order... but where is the shipping cost? Any code or link would be very helpful. Thanks. --------------Solutions------------- Assuming that yo

  • Issue with stock update on amazon with mws 2013-03-21

    We are using the following details for updating the quantity of a product in amazon. Wile using scratch pad, option Feeds->SubmitFeed Set the required parameters and pass the following XML <?xml version="1.0" encoding="utf-8" ?> <AmazonEn

  • MWS Integration 2011-09-08

    I am currently developing a very basic site which will, at this time, simply display order information from Amazon's Marketplace. I have all of the MWS Security Credentials. I have downloaded and reviewed, with much confusion, the PHP Client Library.

  • Retrieving list of Amazon Payments taken for orders within date range 2011-10-25

    I need to write a program that imports payments taken via amazon for items we sell on the Amazon website into our system. According to the Amazon Marketplace Web Service site i can get this information: Amazon Marketplace Web Service (Amazon MWS) is

  • Making an HTTPS POST call to Amazon in Delphi 2007 2012-02-14

    My first question on Stackoverflow - so I hope I don't make myself look stupid! I have used the resource a lot in the past, mainly finding answers from questions others have asked. But this time I seem to be a bit stuck. I can nearly get there with t

Copyright (C), All Rights Reserved.

processed in 0.127 (s). 11 q(s)