Custom Price2Spy format

Custom Price2Spy format

Integrating your store with Price2Spy – using custom Price2Spy feed format

This option will enable you to integrate your shopping cart solution / your own software with your Price2Spy account – no matter what software you may be using.

Of course, there is an important prerequisite: you need be able to export the product data from your software, using the format described below

Of course, if you encounter any problems with importing products into Price2Spy, do let us know

Why can’t Price2Spy do the Reprice of my products using this sort of feed? The reason is pretty simple – the feed you provide to us works as one-way communication (from your store to Price2Spy). However, in order to reprice your products, we’d need 2-way communication, so your store can accept data from Price2Spy. Unfortunately, the feed is designed only for 1-way communication. In order to perform Reprice of your products, please checkPrice2Spy API possibilities

 

Steps to be performed on your store

 

    1. Please export your product feed in one of the following formats
        1. CSV – please check the sample CSV file
        2. XML – please check the sample XML file
        3. JSON – please check the sample JSON file
    2. Place your feed on a publicly available URL. For example: https://www.mywebsite.com/feed/price2spy.csv
    3. Please take care of the following
      1. For CSV – the feed should contain no header row
      2. For CSV – the order of columns in the feed should be as shown below
      3. If you do not plan to use a particular column, you still need to have it in your feed, with empty values
      4. All field names are case-sensitive
    4. Please make sure your feed gets updated at regular intervals (price2Spy will check it once per day)

 

The fields to be used in the feed are

 

  • name – product name (mandatory, must be unique)
  • category – product’s category (not mandatory). Using this field will enable you to filter products / run segmented reports by category
  • sku – product’s unique identifier (not mandatory). This usually helps match your product with products on competitor sites
  • brand – product’s brand (not mandatory). Using this field will enable you to filter products / run segmented reports by brand
  • supplier – product’s supplier (not mandatory). Using this field will enable you to filter products / run segmented reports by supplier
  • internalId – product’s ID from your own database (mandatory, must be unique). This usually helps you link Price2Spy reports to your own database
  • map – MAP (Minimal Advertised Price, sometimes also known as RRP – Recommended Retail Price, or RSP – Recommended Street Price). Not mandatory – but please fill it in if you want Price2Spy to monitor pricing policy violations
  • purchasePrice – your cost price for this product. Not mandatory – but please fill it in if you’d like Price2Spy to suggest possible Clever Drop pricing opportunities
  • bottomPrice – the lowest price you would like to sell this product for. Not mandatory – please use it when creating repricing rules
  • ceilingPrice – the highest price you would like to sell this product for. Not mandatory – please use it when creating repricing rules
  • url – the URL of the product page on your site (mandatory). If you do not supply product’s price in this feed, Price2Spy will determine your own price by visiting this URL
  • price – product’s price (the final price to be paid by the customer). Not mandatory – please see product’s URL. However, if you do supply product’s price – Price2Spy will not count your own URL in the total number of URLs monitored in your account
  • available – product’s availability – can be true or false. Not mandatory (if left blank, the product will be considered available)
  • note_1, note_2, note_3 – In the Note fields you can add any comment you find important
  • image_1_url, image_2_url, image_3_url – product image URL
  • metadata_1, metadata_2, metadata_3 – These fields are customizable and optionable while enabling you to do the product filtration.
  • custom_field_1 – custom_field_10 – Here you can add optional product info other than sku or internal id
  • comment_1, comment_2 – Comments fields enable you to leave longer product descriptions

Steps to be performed in Price2Spy

 

Please login to your Price2Spy account and do the following

1.Click Misc => Link My Store

Custom Price2Spy format
2.Click PRICE2SPY CUSTOM IMPORT FEED and click Next
Custom Price2Spy format
3. Choose the way we should access your Price2Spy custom import feed

    1.  HTTP(S): Choose this option if your feed is a publicly available URL – you must provide a URL where we can find your complete product datafeed. For example: https://www.mystore.com/price2spy.xml
    2.  HTTP(S) – password protected:  – Choose this option if your feed is password protected
    3.  FTP – Choose this option if your feed can be accessed via FTP

 

4. Fill in the details of how you would like to access your feed

Custom Price2Spy format
5. Select Categories (or leave default = all) from which the products should be copied

 

6. Click Matched products to see how many products are contained in the above categories, click Next

Custom Price2Spy format
7. Finalizing operation details

  • Name your operation (for example My Price2Spy Feed | LINK)
  • Define execution frequency (default = 1 day)
  • Choose whether you want to be notified by email on each operation execution (default = OFF)
  • Check ‘Do it now‘ if you want the products to be copied immediately (otherwise, the operation will be done according to the daily schedule)
  • Define price check frequency (of the products created via Link My Store Operation)

8. Click Finish. Once your products have been linked from your feed, you’ll see them in your Price2Spy account

Custom Price2Spy format

Network / Firewall issues

  • In many cases, we experience that client’s Web server is behind a firewall, which will block our requests. Therefore, please make sure that you have done the following whitelisting changes to your firewall
  • Whitelist specific countries: please white list Serbia and The Netherlands (Holland)
  • Whitelist user-agent: ReactorNetty
  • In case you’re not sure where to apply the above firewall changes, please get in touch with your hosting company. If you’re unsure whom to contact, please let us know, we’ll be happy to point you in the right direction.

Basic Info

 

  • All product-related columns (product name, SKU, internal ID, custom fields, metadata, brand, supplier, and category) can have 250 characters max
  • URL is limited to 2,000 characters
  • The following fields can contain 65,535 characters (64 KB): note1, note2, note3, image1Url, image2Url, and image3Url