Update XML file from another XML file

rubyonrails-talk
1

Hi,

I'm new to Ruby and Rails and trying to use it to work on a project for my website.

I have a Shopify store, which I can access my products.xml feed through the API, Shopify feed sample attached.

I have another feed from the wholesaler I use that has the latest stock levels. Whole feed sample attached.

The common link between the two is the SKU code, as I added all of the products with the same code. The attribute for the stock level isn't the same. On the wholesale feed it's <stock> with Shopify using <inventory-quantity>

I'm trying to work out how to take the wholesale feed, and combine it into my product feed, which I can then regularly apply to my Shopify store to keep it updated with the latest stock levels.

I've been reading a lot, testing Nokogiri and the builder, but I'm not sure if I'm going about this the right way. Currently I think the way forward is to parse both feeds into the same MySQL database and then build a new XML file from that to update Shopify.

However is there a way that I can have the wholesale XML feed check it's SKU code against my Shopify XML, update the attribute field for stock level and append it to the correct product?

My skill level is low, so I'm prepared for this to take awhile, but hoping someone can steer me in the right direction so I'm doing it correctly (keeping in mind that I'm sure there are multiple ways to do this!).

Thanks,

Paul

Attachments: http://www.ruby-forum.com/attachment/5657/wholesalefeed.txt http://www.ruby-forum.com/attachment/5658/shopifyfeed.txt

2

Paul Osborne wrote in post #972462:

I have a Shopify store, which I can access my products.xml feed through the API, Shopify feed sample attached.

I have another feed from the wholesaler I use that has the latest stock levels. Whole feed sample attached.

The common link between the two is the SKU code, as I added all of the products with the same code. The attribute for the stock level isn't the same. On the wholesale feed it's <stock> with Shopify using <inventory-quantity>

I'm trying to work out how to take the wholesale feed, and combine it into my product feed, which I can then regularly apply to my Shopify store to keep it updated with the latest stock levels.

From taking a quick glance at the Shopify API I'd do something like the following:

1. Create a cross-reference table storing item ids from Shopify and SKUs that you'll use to match between Shopify and you wholesaler.

2. Include in that cross-reference the latest inventory quantity, and a flag indicating whether or not the value needs updating in Shopify.

3

Thanks Robert. Your post helped me move forward with this.

I've made good progress and have parsed both XML files into one table to make it simple, I'm now working on getting that data to my Shopify store.

Thoroughly impressed with Ruby, and especially ActiveRecord so far.

4

Hi Paul,

I read your post this morning as I'm setting out to achieve exactly the same objective - updating Shopify with inventory levels from a remote XML (wholesale) feed.

I've got a ROR Shopify app up and running so am set with the authentication side.

Would be really keen to hear how you got on with your project and whether you'd be able to offer any advice.

Many thanks, David