You are here:  » Import API items Into Database?


Import API items Into Database?

Submitted by ItsDavid on Thu, 2016-04-14 13:42 in

Hi, I might be asking to much but thought i would give it a try.

Is there anyway to import my API Products and Coupon Feed into the Price Tapestry database from my XML files that are created so that when products or coupons are searched or viewed i do not have excessive API calls going over my limit?

Because as it is now when i add a feed for example my coupons offered by my networks i have to create a feed URl and file for each page offered for that coupon feed so if i have a feed with 20 pages i have to create 20 feed URL's now when we get to products the steps are the same so this can become 100's or 1,000's of XML files and feeds very quickly and i don't want to run into problems of going over my API limits.

I have been trying to research to see if there is a possible way with curl to get all pages of each feed and saving it to one file while also keeping in mind to allow it breaks (slow importing) to avoid out of memory problems.

Is this possible or am i dreaming to big?

Thank you for your excellent support here.

Best Regards.

Submitted by support on Thu, 2016-04-14 13:53

Hi David,

Trying to treat API results as feeds is not ideal - generally speaking, a provider offers an API because a feed is not appropriate for whatever reason, so there is never going to be any straight forward way of handling them as such.

However, bear in mind that Price Tapestry supports any combination of;

- Individual feed per merchant
- Multiple feeds per merchant
- Feeds containing multiple merchants

...so there is no reason why multiple API calls that return an XML or CSV response that is functionality equivalent to a feed cannot be set-up as individual Automation Tool jobs, and registered using duplicate merchant names - that will work just fine, the de-duplication (unique combination of merchant + name) still applies even if distributed across multiple feeds...

Cheers,
David.
--
PriceTapestry.com

Submitted by ItsDavid on Thu, 2016-04-14 14:12

Can you point me in the right direction to documentation to learn more about these features below?

- Individual feed per merchant
- Multiple feeds per merchant
- Feeds containing multiple merchants

Thank You

Submitted by support on Thu, 2016-04-14 14:28

Hi David,

On Feed Registration Step 2, you can either enter a merchant name manually, ~or~ select a field from the feed that contains the merchant name.

It is the option to use either method when registering any feed that supports the 3 combinations;

- Individual feed per merchant

Manually enter the merchant name on Feed Registration Step 2

- Multiple feeds per merchant

Manually enter the merchant name on Feed Registration Step 2, since there is nothing stopping you having more than one feed for the same merchant. Products still have to be unique of course...

- Feeds containing multiple merchants

Select a field from the feed that contains the merchant name on Feed Registration Step 2. The merchant name is then taken from the feed instead of the value entered manually.

Hope this helps!

Cheers,
David.
--
PriceTapestry.com