Bagesh Singh Web Developer

Tapestry Script : Affiliate Price Comparison Script for PHP and MySQL

Price Tapestry is a PHP and MySQL price comparison engine, magic parser, based on a PHP database design and a subsidiary of product information, automatic recognition and analysis of data transmission line of any file format. The script contains a simple and effective front-end designed to be easily customized for your use only HTML and CSS. Your purchase you are entitled to unrestricted use (such as many web sites to create what you want), the complete source code, including magic analyzer, and unlimited friendly help and technical support!

Feature Summary (the full list of features and more screenshots)

      * XML import of any product or CSV datafeed into MySQL
      * Applies to any currency, such as the British pound € $, etc.
      * Search engine friendly navigation throughout the site
      * Google Maps automatically generated
      * A simple management interface
      * Very easy to install

See the official price tapestry presentation at:

      * WebPriceCheck.co.uk
      * WebPriceCheck.co.uk Management Area
        (Username: "demo" Password: "demo")

Installation

     1. Extract assigned to a temporary directory on the local computer.
     2. Open the file config.php.dist (see below) to a text editor, then save it as config.php in any changes, the need for your server. Click here for a description of each variable.

        "? PHP's
          $ Config_title = "Site Name";
          $ Config_charset = "UTF - 8's";
          $ Config_baseHREF ="/";
          $ Config_useRewrite = false;
          $ Config_useRelated = false;
          $ Config_useTracking = false;
          $ Config_useJavaScript = false;
          $ Config_useInteraction = false;
          $ Config_currencyHTML = "";
          $ Config_resultsPerPage = 10;
          $ Config_databaseServer = "localhost";
          $ Config_databaseUsername = "";
          $ Config_databasePassword = "";
          $ Config_databaseName = "";
          $ Config_databaseTablePrefix = "";
        ? "
     3. Upload files and directory structure of your Web server.
     4. Browse to setup.php. The following should appear:

       Check the database connection password ...
       Check the database options ... Password
       Check the database table ... failed [Click here to install the table]
     5. Click on the link to install the database table. This completes the basic installation process. Now you can manage your website navigate to the / Management / subdirectory.

Feed Management

Add a new merchant

     1. Uploaded back to the merchant's products / feed / directory.
     2. Navigate to the / Management / directory of the price of Tapestry installation.
     3. Click the file name next to the register you just uploaded.
     4. Waiting for feed format auto-detection to complete, and then click Next.
     5. If the auto-detection is successful, you will be able to see the contents of the first record of a product displayed in the bottom of the page. If you can not see the first record, click the backup and manually select the correct file format from the drop-down menu.
     6. Enter a name, merchants, and use the content, the first record from the feed, choose which areas of the corresponding product name, description (optional), Image URL (optional), purchase web site and prices. If necessary, type and / or brand information in accordance with any part of the index fields, or select the appropriate fields feed.
     7. Click to register and registration of imported feed and the trial of the top 10 products imported record, a quick test to ensure that all the work.
     8. Go to home page of your site and follow the link to visit the merchants, and then click the name to browse the new business through product records and check everything is normal.
     9. If all goes well, return to the management page, click the Import the new file name next to the records of imports of all products. This process may take a few minutes the product information and thousands of records.

Update business products

     1. From the latest business product back to the / feed / directory, and make sure to use the same file name of the feed.
     2. Navigate to the / Management / directory of the price of Tapestry installation.
     3. Click the link to import feed. Feeds as long as you do not need to re-register to update them as long as the format has not changed.

Remove merchants

     1. Remove store product feeds from / feeds / directory.
     2. Navigate to the / Management / directory of the price of Tapestry installation.
     3. Click the link to cancel the registration of the disappearance of feed and products removed from the feed.

Filters

General

There may be situations, you need to change the product data before importing. The most common situation is that, when the feed does not contain your actual affiliate URL, but can be directly linked to business Web site (in this case, you may need to follow links on this website), or in the URL contains the holder's place, you must replace your affiliates ID.

Filters are applied in the order they were created, you can add multiple filters require each feed. When the filter is configured for a particular feed, they will continue to hold, will be applied as long as the future of imported feed.

To add a new filter or modify an existing one, click the filter next to the feed you want to configure the filter. You can then select an existing filter to change its configuration, or use the form to create a new filter - in this case select a filter type you want to add fields from the feed to it should apply. Filter configuration is as follows:

Search and Replace

Search: Enter you want to match in this area

Replace: Enter the text you want to replace the matching in this area

The text before the

Text: Enter the prefix you want to select the field, which may contain a placeholder reference value in other areas of feed. Footprint, including field names (such as feed, see the registration page) sealed in the% character, for example, "% delivery%" (without quotation marks).

After the text

Text: Enter the suffix you want to the selected areas, which may contain a placeholder reference value in other areas of feed. Footprint, including field names (such as feed, see the registration page) sealed in the% character, for example, "% delivery%" (without quotation marks).

Name of Case

There is no configuration parameters for this fitler. Filter the selected field into "one case", for example, "Sony plasma" will be changed to "Sony plasma."

Records fall

Decline in the record, if the field contains the text: Enter the match. If the selected field contains the written records will be deleted from the import process. You can leave this field blank if you want to match an empty field.

UTF8 encoding

There is no configuration parameters for this fitler. This filter will convert a field in the feed-coded ISO - 8859 - 1 character set is UTF - 8. Use this filter if your site is configured for UTF - 8 character set, but you want to import the feed is ISO - 8859 - 1 encoding. You usually only need to apply this filter to the product name and description fields.

UTF8 decoding

There is no configuration parameters for this fitler. This filter will convert a field in the feed-encoded UTF - 8 character set import ISO - 8859 - 1. Use this filter, if your site is configured to ISO - 8859 - 1 character set, but you want to import the feed is UTF - 8 encoding. You usually only need to apply this filter to the product name and description fields.

Pruning

There is no configuration parameters for this fitler. The filter will remove any blank before or after the text from the selected fields.

Category Map

Category mapping enables you to create a single master category name used to replace any number of other names may be found in different feed. For example, suppose you have two feeds with TV, but a class of feed used in "TV" and other purposes "TV." You can create a class map to all imports of these products under a single category of "TV."

Create a new category of mapping

     1. Mapping the Admin menu by category.
     2. Enter the name of a new class of single-master, you want to use, such as "TV", and then click Add.
     3. Enter a name for each alternative category name into the text box and click Save to store the new mapping.
     4. The new map will not take effect until the completion of all the affected feed have been imported.

Product Map

Mapping categories, like product positioning enables you to create a single primary product names used in lieu of any other number of names may be found in different feed. This feature is only true tips, niche sites, the number of products, management needs to be mapped.

Create a new product positioning

     1. By product positioning in the Admin menu.
     2. Enter the name of a new single primary product name, you want to use, and then click Add.
     3. Enter a name for each alternative name into the text box, then click Save to store the new mapping.
     4. The new map will not take effect until the completion of all the affected feed have been imported.

Specialty Products

Specialty products to make your product information display the default home page, and provide a model code that need to use the information from the database the price of tapestry in your web site's home page.

Editors

     1. Click characteristics of products in the Admin menu.
     2. Enter the name (or names) of the product (screw) you want to feature on the home page in the text box.
     3. Click Save to store the list of specialty products.
Moderate Comments

Moderate pending review of

     1. From the administration menu under the ordinary evaluation.
     2. To make any changes to our opinions and requests.
     3. Click to accept or reject the request.
     4. The review will backfill to the database, once all the pending moderations have been completed.

Automation Script

Automation scripts located in / scripts / directory. Their aim was to implement the command line or from another PHP script, shell script (Linux server) or a batch file (Windows server).

      * Import.php
      * Register.php
      * Copyfilters.php
      * Copyextras.php

import.php

All imported feed, feed changes, or designated feed.
Description
import.php [@ All | @ Modified | "filename"]

This script imports the specified command-line feed (S) and reconstruction, product database and index-related businessmen. It will deal with files have been registered to the system. The script requires a parameter. Or specify a file name, or use @ ALL, so that all registered imports of feed or @ modified to only those who imported feed has been modified since the last import.
Examples
All PHP-import.php @
PHP-import.php @ Modified
PHP-import.php ExampleMerchant.xml

register.php

Register a new feed into the system.
Description
register.php
"File name" "format <merchant> <fieldName> <fieldDescription> <fieldImageURL> <fieldBuyURL> <fieldPrice> <fieldCategory> <userCategory> <fieldBrand> <userBrand>

The registration of the specified command-line script to feed into the system. This script is useful for bulk feed, product registration affiliate network in the same format and fields in which the mapping will be the same for each business. Find out what the value of using a simple sign up for an example of feed-use management interface.

The file name is the name of the feed, must appear in your / feed directory. The name of the business you want to show the entire site merchant. Magic analyzer format string format is to describe the data representation.

The field name is the name of the field name associated with the product. fieldDescription is the field name and description of products. This field is optional, in which case an empty entry must be specified, for example: "." fieldImageURL is the field name of the image of the product-related websites. This field is optional, in which case an empty entry must be specified, for example: "." fieldBuyURL is the field name associated with your affiliate products. fieldPrice is the field name and price products.

fieldCategory is the name of the field contains the name of the product category. Or, it can be left blank (such as ""), all products in the feed can be assigned to a single type userCategory. fieldBrand is the name of the field contains the product's brand name (manufacturer). Or, it can be left blank (such as ""), all products in the feed can be assigned to a single brand to provide userBrand. All types and brands fields are optional, in which case an empty entry must be specified, for example: "."
Example
PHP-register.php widgets.txt "of the CSV | 34 | 0 | 1" "widgets online", "product name", "description" "image" "DEEPLINK", "price" "MASTERCATEGORY" "" "BrandName "" "

copyfilters.php

Copy the filter configuration from a register of feed to another.
Description
copyfilters.php <sourceFilename> <destinationFilename>

This command-line script to copy all filters and sourceFilename the destinationFilename, remove any existing filters to specify the target file. This script is usually used when the feed bulk registration number from the same network of partners, all the feeds, the network needs a specific filter configuration. You must have a configuration similar to the filter feed at least one group-use management interface.
Examples
PHP-copyfilters.php widgets.xml of Books.xml

copyextras.php

Additional copies the description field from a register of feed to another.
Description
copyextras.php <sourceFilename> <destinationFilename>

This command-line script to copy all the additional description field is configured to destinationFilename right sourceFilename, delete the existing description of any additional field configured for the specified target file. This script is usually used when the feed bulk registration number from the same network of partners, all the information will benefit from the additional description of the same field configuration.
Examples
PHP-copyextras.php widgets.xml of Books.xml

Additional installation steps

Enable search engine friendly website

These instructions apply only to Apache web server. htaccess configuration for each directory covering the opening. As for other Web servers to support a similar URL rewriting mechanism is simple to use content htaccess.txt reference, skip to step 3 the following description.

     1. Open the file htaccess.txt to a text editor, then save it as. htaccess modifications, RewriteBase if you are not ready to install the prices of tapestries to the root directory site.
     2. Upload. htaccess to the top price tapestry of your installation directory.
     3. Is set to TRUE $ config_useRewrite in config.php.

Google Site Registration

To register automatically generated file, Google Maps for your installation of the price of Tapestry to create a Google Sitemaps account, or log on and follow the instructions to register the complete URL sitemap.php. The script generates a Sitemap index contains links to fully map every business on your website.

Product feed "format string" specification

The format almost all subsidiaries of the product information will automatically detect the analyzer. If the format string is not the right decisions, and the format of the product feed, nor shall the drop-down box, you can use the following information in order to develop the correct value to use. Format string value contains a number of parameters separated by pipe ("|") characters. If you have problems registering a new product information and want to help, simply contact us via e-mail and product feed is attached (compressed if possible).
XML format
Parameter Description
1 - basic types of "XML" (without quotation marks)
2 - repeating element of the XPath expressions XPath elements of duplicate files, for each record. For example, the repeating elements XPath for the XML feed to join the window is "Product / Products /" (without quotation marks)
CSV format
Parameter Description
1 - Basic type "CSV" (without quotation marks)
2 - field separator for ASCII character code of the field separator. Shared values include: 44 (comma), 9 (card), 124 (tubes) and 59 (semicolon). Can be any character code in the 0-255 range.
3 - the header row? 0 (no) or 1 (yes)
4 - text delimited ASCII character code delimited text. Shared values include: 34 (double quotation marks) and 39 (single quotes). Can be any character code range of 1-255. 0 means no delimitation of the text.
Examples
The XML | Products / Products / XML documents, records enclosed <products> <Products "..." / products "" / products "
CSV format | 44 | 0 | 0 CSV files, comma-separated values, there is no header row
CSV format | 9 | 1 | 0 CSV files, tab-delimited values, header row

Useful support forum topics Index

Handling of imported timeout

Affiliate Network Products Feed Website

Including the description field in the search

Replaced by products of random specialty products

Products Feed Download Automation Guide (Linux server)

Show search and price comparison tables on other sites

Enable gzip compression in order to increase the coverage of search engines

Character encoding uses non-English language Web site

Expanded areas of database architecture and other products to increase your web site

On the MySQL server, the configuration of a very large site (one million + products)

API Integration - Amazon

API Integration - eBay
Handling of imported timeout
Submitted dmorison on Wed, at 10:41 on October 18, 2006. Price Tapestry

Some web hosting companies / dedicated servers, by their default PHP and / or the Apache configuration, apply quantitative restrictions to the time a PHP script can run. This is to protect their servers from the wrong script may consume ever-increasing resources, so the impact on the performance of servers.

If there is such a limit is usually set to 30 seconds. If the limit is reached during the import of PHP you might see an error message (maximum execution time over), if it is a PHP restrictions; or the connection may simply be discarded caused by an error message displayed in the browser (with a connection service device can not be established), if it is imposing restrictions on Web server.

PHP-imposed time-out

Usually, this will involve calling for support on the desktop to your hosting company. Explained to them that you are running a script, is a large file handling, and you want to have a time limit cancel your account. In most cases, your host will cancel the restrictions to keep your business. However, contact your host, you can try to add the following statement. htaccess file in the top-level directory of the Web site:

php_value max_execution_time only 0

Web server impose timeouts

If a timeout caused the server error or the page did not load you can import a large feed use of automated scripts, these are not the network access server. To access the automated script, you need to be able to log on to your hosting account via Telnet or SSH and the ability to execute commands. A popular SSH client for Windows is the putty, you can download from here:

http://www.chiark.greenend.org.uk/ ~ sgtatham / putty /

If you do not know if you SSH access to your account is worth just thinking about it anyway - and opening up and choice of putty SSH as the connection type. And then enter the same details (host name, user name and password), you would use it to access the FTP server hosting account. If you get a connection, you will see a command prompt ($), you can start typing commands. This command uses the Tapestry automation script price is as follows:

$ CD-ROM path / to / pricetapestry / scripts
$ PHP's import.php <file name "

Where, <filename> is the file name, you have already registered to use management interface.

Finally, we should always give priority to the text using the XML feed file version, if both can, because they are much faster. In general, almost all of the escrow account up to 10,000 products can be imported from the XML feed in 30 seconds.