Data feed file integration price comparison shopping script

Documentation Wiki - - Online merchant datafeed integration for affiliates : dffPSE

HomePage | Categories :: PageIndex :: RecentChanges :: RecentlyCommented :: Login/Register
Home Affiliate FAQ Merchant FAQ Examples Merchants Networks & Programs Forum Blog Wiki Knowledge Base Login

DFF Price Search Engine (PSE)

see all possible parameters / options for PSE | Advanced Search Tip

PSE stands for Price Search Engine. DFF PSE allows you to search by keyword, store, brand, category, etc...
PSE results can be filtered by price range and sorted by price, best match, merchant name, etc...
PSE supports logical OR search options and support word negation by using (-) minus in front of a specific keyword.

We consider PSE to be our strongest and most flexible script or tool. See PSE in action here.
PSE is a shopping search engine. The user input parameters into the PSE and the PSE will output the search results.

How to control PSE? (filtering)
PSE is very flexible because you can control the result of the search engine using any of the following criterias:
  1. specific Keyword : Example - Wizard - How to integrate - Advanced Search Tip
  2. specific Category : Example - Wizard - How to integrate
  3. specific Store : Example - Wizard - How to integrate
  4. specific Manufacturer/Brand : Example - Wizard - How to integrate
  5. specific Price Range min to max : How to integrate
  6. specific Order / Sorting of search result : How to integrate

We are showing examples above using PHP, however we also examples using other programming languages we support. See official example site for more language options.

Use Automatic Code Generator
We have a online wizard to help you generate Javascript, PHP and ASP include line code for both PSE and PSE CSS.
  1. PSE Wizard (affiliate login required)
  2. PSE CSS controllable Wizard (affiliate login required)

Manually Generate Paramaters for PSE
For the most flexibility, you should consider reviewing our List of all possible parameters / options for PSE.

How to sort Search Result? (sorting)
Once you have executed a search request into PSE, PSE will return data output in the form of Javascript, HTML, XML or JSON, you can control the order of the search result by specifying the Sort By criteria. Learn how to control PSE order of search result.

How to control Design, Color and Style?
If you are using Javascript output or HTML output via any of the dynamic web scripting language you can control the styling of the search result output in several ways.
  1. The easiest way, but least flexible is using DFF Template. DFF Template was our initial attempt to allow affiliate to set and store template (color, font, background, etc...) into our database and given a particular DFF Template #. This DFF Template # can then be used in the DFF Javascript or Dynamic Languages calling line query string as an optional parameter. The GET query string variable is usually named 'style'. In the GET query string parameter it looks like this ...&style=12345... where 12345 is the DFF Template #.
  2. The second way to control styling is by using DFF's CSS PSE. We have created a different PSE which outputs certain CSS DIVs and SPANs which affiliates can combine or override with their own styling. We also call this PSE CSS our PSE version 2. How to use PSE with CSS compliant output. How do I determine which PSE version I am using?
  3. The third way, using DFFML + JSON, is currently still under construction.

JSON / XML Output Explanation
When using JSON / XML search results are returned in raw data format (either XML structure / JSON format converted to native array).
The output always contain a statistic section, merchantlist, categorylist, pricelist and most importantly the productlist.
All of the sections are self explanatory except for productlist, where there you must understand the logic behind DFF's product database organization.
Basically, DFF product database have 2 kind of product: (1) DFF SKU products also known as corenum, (2) Merchant Product also known as prdtid.

DFF SKU (aka corenum) is a unique number assigned for a particular uniquely identified product. We assign a unique number starting from 100 and greater. DFF will not reuse SKU #. Each SKU # always represent a unique product. DFF SKU# assigned for particular product will always be assigned to that product (will not ever change). Most of the time once a SKU # has been assigned, there are usually more than 1 merchant selling that particular product, therefore it is a comparable product amongst multiple merchants. When displaying PSE search results, you should check if corenum > 0, if it is >0 means it is a valid SKUed product and therefore it will have min - max price, sellercount (how many merchant you have selected sells that product) and list of merchants numbers (mernum) selling that product. Once you have identified a particular search result as a SKUed product the click-through from that one row / listing should be directed to DFF's PPC (product price comparison) where a list of merchants along with their prices, availability, rating, etc will be shown.

If DFF SKU (corenum) is NOT >0 (is not greater than zero) then it is not a valid SKUed product. Instead of relying on DFF SKU / corenum you should focus on prdtid. Prdtid is a unique identifier for a single unique merchant product. Unlike DFF SKU / corenum, prdtid will change every 24 - 48 hours as we re-import / refresh data from merchants data feed. Therefore you should NOT rely on the min - max price, sellercount, nor will it have a list of merchants. When corenum is NOT > 0 it means the product is a single merchant product. It is not comparable against multiple stores and click-through from this search result should NOT be directed to PPC (product price comparison) script. Instead the shopper should be sent directly to the Store's web site via DFF product click script. A DFF product click script will need at least two required parameters which are prdtid and affid. Here is an example of a DFF product click URL:

There may be other parameters passed behind the URL above, but affid and prdtid are the basic requirement. DFF product click will redirect traffic from your site to DFF, then to the affiliate network, then to the merchant's web site. This script will also perform the 4th click shared commission affiliate ID substitution.

Getting RAW data from PSE
Sometimes no matter how much flexibility we provide to control output and design, they are just never enough to satisfy the pickiest web designer / programmer. If you are that picky, we hope you are willing to take up the challenge of having full control which means you will have direct access to the data via XML and JSON. Having raw data means you will be responsible solely to compose your own page layout and even the navigation and flow of your site. We recommend XML and JSON integration for medium to advance programmers only (or if you know a good programmer).

Downloading DFF's Product SKUs (data feed or database of products with unique UPC / EAN / ISBN)
We have a downloadable product sku data feed for advanced programmers who would like to have their own database of products downloadable via FTP.
See DFF Product SKU data feed export at

PSE Data Query Testing Tool
We have a data query testing tool to help test the affect of the Price Search Engine parameters located at Affiliate Login > Support > Debug > PSE.

Using your own No Image Thumbnail instead of DFF's generic one
You can change the generic no image thumbnail with your own image.
Click here to learn more about this alternate image feature.

Still need more customization
If you need a custom search result from our PSE or have special integration needs which are not available from our current solutions offering, DFF developers can perform custom programming for you for a reasonable fee. Contact Us to get a quote.

There are no comments on this page. [Add comment]

Integrate price comparison shopping data feed file from thousands of online merchant product data feeds | Valid CSS

Page was generated in 0.0281 seconds