Product Feed / Price File

GavinBinding
New Member
5 0 0

Good morning, 

We are currently in the process of signing up with a price comparison website called PriceSpy.co.uk. They have requested a product feed and stated Shopify should be able to generate one automatically. This is beyond my knowledge. Here's the requirements as set out on their website; 

"Faster updates – give us your price file
A price file helps to index the products and prices in your shop. It is placed on your servers and contains information about, for example, products, prices and stock status. We read the price file several times per day to keep the information on PriceSpy updated. If you use an e-commerce system, it’s very likely that it can create a price file automatically.

You register your price file while registering your shop. You can also register it afterwards by emailing our support. If you email us, you only send the link to the file, not the entire file. If you rename the price file, move it to another location, or make other changes that may affect our reading, please email us again.

If you haven’t got a price file, we will have to scan your shop using our agents. This has disadvantages for us, our users, and for you. The changes you make in your shop won’t be shown on the PriceSpy site as quickly, and scanning your shop may put a higher load on your servers.

Price file requirements:
The price file should should have a static URL that doesn't change.
The file does not have to be static, but can consist of a script that dynamically retrieves the information directly from the shop's database. If the file is static, make sure it’s updated frequently so that we always display the correct information on PriceSpy.
The price file can be a regular text file. We prefer text files to complex XML standards, but we fully support Google Shopping’s XML file. However, we do not support Excel files (xlxs, xls) or the like.
The fields in the price file should be separated by tabs, semicolons, or other appropriate characters not used in product names or other fields. Specify what each field contains in the first row of the file.
Different versions of the product, such as sizes or colours, should be listed as a new product with a unique name and article number. We group them in our system if appropriate.
The price file must contain your entire shop range."

If someone could point me in the right direction, I would be most grateful. 

Best wishes

Gavin 

0 Likes
StarPC
New Member
3 0 0

Hey mate, you can try your feed file.

 

If you want to send them info on all your products:

yourwebsite.co.uk/collections/all.atom

 

Or create a pricespy collection and add all products you would like to get them to display to it.

yourwebsite.co.uk/collections/pricespy.atom

 

Let me know how you get on.

 

Kind Regards

Andrew

 

0 Likes
GavinBinding
New Member
5 0 0

Hi Andrew,

Thanks for that. I will fwd it on. 

Best wishes

Gavin 

0 Likes
GavinBinding
New Member
5 0 0

Hey there 

They responded "all.atom files contain only a sample of 50 products, we cannot use this feed".

I am at a lost on this one 

 

0 Likes
StarPC
New Member
3 0 0

Hey Gavin,

 

So sorry I haven't replied. Hopefully someone else stumbles on this and this helps them. In the end this is what I managed to get to work for lists over 50.

Step 1 - Create a CSV or TXT file in excel and use the following titles

Product IDCategoryManufacturerTitleLink (url)PriceConditionSKUStock

 

 When its comes to Category something like this: AUDIO & VIDEO > SPEAKERS & HEADPHONES > HEADPHONES in the tab

 

Step 2 - Download CSV file from Shopify and basically delete all the files/tabs that are irrelevant. This may take a while if you have massive descriptions.

Step 3 - Copy data to previously created CSV/txt file. I created a help tab for categories I needed and just copied and pasted as required.

Step 4 - Save and upload to Shopify files, copy the file name https://cdn.shopify.com/s/files/....

Step 5 - Create a redirection in the NAVIGATION TAB url redirects are next to Add menu (redirection should be like /pricespy) then paste the file name into the redirect to line.

StarPC_0-1614156915036.png

Step 6: Let whomever is taking the feed file know the redirect address i.e if you put /pricespy the address would be www.mystorenamehere.com/pricespy

 

This is what I had to do. Just remember to keep it updated as it does not get automatically update, relys on the human to keep accurate records. However, if you keep it to match your Shopify CSV, its not too hard.

Hope this helps people out

0 Likes