Integrate my PS with Amazon

[rseigel]

Hi all,

 

I have what should be a relatively simple job for someone here.

 

I'm trying to integrate my PS with Amazon so it will update my inventory automatically with Amazon.

 

There's an Amazon API and I've already written the SELECT to get the exact info that I need. There is also a Amazon developers guide and code samples to get it to work.

 

SELECT product.reference AS sku, product.price - specific_price.reduction AS price, stock_available.quantity, product.ean13 AS 'product-id', 'ASIN' AS 'product-id-type', product.condition FROM product, specific_price, stock_available WHERE product.id_product = specific_price.id_product AND product.id_product = stock_available.id_product;

 

I just can't wrap my head around it. This info essentially needs to be turned into an XML feed as per Amazon's specs and placed where the script can grab it (every hour in my case).

 

Please reply here or via PM with expected cost and time it will take. I would prefer if you already had experience with the Amazon API but any great coder would be fine I'm sure.

 

I'll pay 50% up front and 50% upon completion and verification that it works as expected via PayPal.

 

Yes...I know there's a PS Amazon addon. It's overkill for what I need and I've already spent countless hours customizing things the way I need them to work.

 

There is no need to turn this into an actual module. Just two independent scripts (one to create the XML feed and one to send it to Amazon - or it could be combined I suppose - all ran with a CRON).

 

BTW....there will be more work on an as-needed basis for the right person.

 

Cheers,

 

Ron

Edited August 4, 2013 by rseigel (see edit history)

[rseigel]

Thanks to everyone for looking.

 

I found a dynamite developer who is doing the work for me.

 

Cheers,

 

Ron

[rseigel]

Ok...false alarm. My original deal fell through.

 

Anyone else interested in taking this on (I have one person here that I'm waiting to hear back from but I'm open to other offers while I'm waiting).

[rseigel]

I have a couple of small things to add to the scope:

 

--------------------------------------------------------------

According to Amazon you can only use Purge and Replace via the MWS once every 24 hours.

 

You can Update as many times as needed.

 

So, the change is I need one script that will do the purge and replace that I can set on a CRON every 24 hours and one that can just update the inventory numbers to be run once and hour via CRON.

 

This should be a matter of literally changing one line (I hope).

 

Also, you'll need to ONLY use the products that have an ASIN attached (in the ean13 field). The others will need to be disregarded. Essentially if the EAN13 field is empty skip that product and go to the next. Again, this shouldn't be a big thing.

--------------------------------------------------------------------------

[benjamin utterback]

Hi rseigel, just wondering why you think the Module is overkill? You think it won't work for your customized website? I'm not so sure that the API integration is all that simple, and I would guess that the cost of developing and integrating these scripts may be greater than the module itself. That said, if you need to further customize the module in order for it to work for your store, that statement may be untrue.

[rseigel]

Well, I found someone here that's working on exactly what I want for $120US. API integration with AWS is simple for those with more experience than I (I've written some custom scripting for my site but nothing for an API).

 

He has experience with AWS and I get what I want.

 

Works for me.

 

I should also add that I found someone here that will have this delivered to me by tomorrow.

 

Again, thanks all for looking.

[benjamin utterback]

That's great to hear!

 

I never thought that you could find an API integration like that for so little. Good for you! What works for you works for us

 

Have you found this Job Offer Forum to be helpful?

[rseigel]

When a developer has essentially done something very similar for someone else it's easy enough to charge less.

 

I haven't found this forum much use (until now) but then again I haven't made a lot of friends here. Most don't like to hear the bitter truth.

[benjamin utterback]

Well, I'm happy you stuck with us

 

You found this developer from this Forum? Have you placed your Offer anyway else? I'm just curious as to what the offers would be.

[rseigel]

Yes.

 

Posted it on freelancer. Was offered it for $200. Didn't trust the developer though so I passed.

[Dh42]

Please update us tomorrow on how this module / modification works out for you, I am dying to know.

[rseigel]

Should be up and running soon.......

 

Fingers crossed.