jahwise Posted November 11, 2005 Share Posted November 11, 2005 Greetings, I have an OSCOMMERCE site at http://www.loopwise.com/shop and I am looking to follow the instructions seen below to add www.zzounds.com products to my site. I am unsure of the best way to go about integrating this feed into my existing Oscommerce Shopping Cart, but I would like to pay someone who has a keen understanding of this process to complete the project with me. There are about 6000 products in the feed. EXPECTATIONS: -50% up front 50% when completed -$5 for every day project is overdue -1 month time frame -work to be performed on my server / site directly If you are interested in working with me on this project, please outline for me what your understanding of the project is, and how EXACTLY you will go about completing the project. I need to specifics of your strategy and what you will be doing at what stages in the process. Thanks for your interest! -taylor https://www.zzounds.com/aff--feedaccess zZounds Data feed Access Download the feed using one of the following methods: Use a web browser. Good for interactive use. The URL is: https://www.zzounds.com/feed-pickup/feed--affiliate.txt After entering the URL and hitting return to go to the site, you will be prompted to enter your username and password. The username is your affiliate id and the password is your affiliate password. You can avoid the username and password prompting if you include these in the URL. Use the standard format for these requests: https://username:password@host/path If your affiliate id was 99999 and your password was "mypass", then the URL would be: https://99999:[email protected]/feed-p...--affiliate.txt Use the GNU wget application. Good for use in a script and/or for more advanced users. Example Usage: wget --http-user=AFFILIATE_ID --http-passwd=AFFILIATE_PASSWORD https://www.zzounds.com/feed-pickup/feed--affiliate.txt The username is your affiliate ID and the password is your affiliate password. The general GNU wget information page is located here. The feed will be saved as "feed--affiliate.txt". If a file with this name already exists, wget will not overwrite the file but will instead save it with a version number, e.g. "feed--affiliate.txt.1". Since this behavior is likely to be undesirable for most users, you should delete or rename the existing "feed--affiliate.txt" file before starting a new download with wget. Windows users should follow these steps to install wget. Create a Directory in which to store the wget application and related files. We recommend "C:\Program Files\wget". If you are running Windows 2000 or XP and you do not have administrator privliges on your machine, you can still use wget. Just specify a different installation directory. wget will run from any directory location and it does not make or require any registry changes. Download the primary wget zip file and unzip the files into the new directory you created in step 1. Download the SSL library zip file and unzip the files into the new directory you created in step 1. You can now access the wget application using the Windows Command Prompt. Keep in mind that you will need specify the wget path you used for installation when calling wget, i.e. "C:\Program Files\wget\wget" or you will need to add this directory to your path statement. You can also just "cd" to this directory and call wget directly. Windows users should follow these steps to use wget. Open up a command prompt. On Windows 95 & 98, this is accessed from Start->Programs->MS-DOS Prompt. On Windows NT 4.0, 2000 and XP, this can be accessed under Start->Programs->Accessories->Command Prompt. Running wget from Start->Run is not recommended as wget expects a command prompt enviroment to display normal messages and errors. If you run wget from the Start-Run window, Windows will temporarily create a command prompt for wget, but as soon as wget finishes, it will delete the temporary command prompt before you have a chance to read the wget messages. Use the "cd" command to change to the directory to where you want to store the downloaded file. Use the wget command as described above under "Example Usage:" bullet. Also, refer to the wget session transcripts below to see what should occur. A complete wget session on a Windows system will look like this: C:\temp>c:\progra~1\wget\wget --http-user=XXXXX --http-passwd=XXXXXXXX https://www.zzounds.com/feed-pickup/feed--affiliate.txt --16:57:08-- https://www.zzounds.com/feed-pickup/feed--affiliate.txt => `feed--affiliate.txt' Resolving www.zzounds.com... done. Connecting to www.zzounds.com[66.147.161.22]:443... connected. HTTP request sent, awaiting response... 200 OK Length: unspecified [text/plain] [ <=> ] 2,988,131 174.21K/s 16:57:46 (174.21 KB/s) - `feed--affiliate.txt' saved [2988131] C:\temp> A complete wget session on a Unix/Linux system will look like this: sounds:/home/au$ wget --http-user=XXXXX --http-passwd=XXXXXXXX https://www.zzounds.com/feed-pickup/feed--affiliate.txt --22:42:54-- https://www.zzounds.com/feed-pickup/feed--affiliate.txt => `feed--affiliate.txt' Resolving www.zzounds.com... done. Connecting to www.zzounds.com[66.147.161.22]:443... connected. HTTP request sent, awaiting response... 200 OK Length: unspecified [text/plain] [ <=> ] 2,781,009 171.63K/s 22:45:07 (171.63 KB/s) - `feed--affiliate.txt' saved [2781009] sounds:/home/au$ The data feed is dynamically generated, it can take a few minutes for the download to start after the https request is initially received. If you are using wget, this pause will occur after this message is displayed: "HTTP request sent, awaiting response...". The size of the data feed file is about 2.5MB. Access using the FTP protocol is not offered. As the data feed is dynamically generated when each affiliate requests it, it may take up to a minute for the feed to start downloading after the initial HTTP or wget request is made. This delay will occur after username-password authorization. Data feed access is limited to approved affiliates. The data feed can be retrieved only once per hour. We recommend that you update your site daily, but you can update more often if you choose. Data feed File Format The data feed file is a standard tab delimited text file with these features: Simple 8-bit text file, i.e. not Unicode. Field names are in the first row. Fields are delimited by the tab character. Lines are delimited by newline & carriage return characters, i.e. standard windows text file format. Character fields are NOT enclosed by quotes. In the future, we may augment the data feed file with additional fields. Examples could include a promotion field that indicates that the item is on sale, being closed out, etc. We already have tentative plans to add 2-day and overnight shipping costs. Although we will give you advance notice of any changes in the file, you will probably find it advantageous to design your file importation routine so that it can read a file with extra fields without breaking. This way, if you choose not to use the new fields, you site can continue to operate without intervention on your part. While we expect that we may add fields to the file in the future, we do not anticipate changing or dropping any of the existing fields. File Fields Name ? Name of Product. Character Field, Up to 128 Characters. Description ? Short Description of Product in text. No HTML. Character Field, Up to 1024 Characters, although most descriptions will be only 3-4 lines long. SKU ? Product SKU. Character Field, Up to 20 Characters. URL_Product ? URL for product. This URL includes your affiliate code so that you can be paid for the referral. Character Field, Up to 255 Characters. URL_Image_Small ? Location of Small product image hosted by ZZ/SDM. Character Field, Up to 255 Characters. URL_image_Large ? Location of Large product image hosted by ZZ/SDM. Character Field, Up to 255 Characters. Price ? Actual zZounds selling price. Manufacturers sometimes restrict us from show prices for some items. If the price is missing, then ?Call zZounds for price must be shown.? You may choose to display only products where a price can be shown. Numeric Field. Price_High ? High selling price range. For most products, this field will be missing. It will be present for items like guitars, where the price can vary according to the guitar?s color and/or finish. If this field is populated, then you should show the price as occurring in a range between the Price field and this Price_High field, e.g. ?from $259.00 to $329.00?. Numeric Field. Price_List ? List price of product. Numeric Field. Category ? Leaf category for product. Character Field, Up to 64 Characters. Manufacturer ? Manufacturer name of product. Character Field, Up to 64 Characters. Shipping_Cost ? Minimum (ground) shipping cost to customer. If 0, then shipping is free and this should be noted on your site as ?Free Shipping? or something similar. Users may feel that a shipping price of $0 is inaccurate and represents a bug. Numeric Field. Other Notes Please keep in mind that the feed will add and drop products as we add or drop them from our master catalog. If a product is no longer listed in the data feed, then you should remove the zZounds link for this product. You can use the category and/or manufacturer fields to select out a manageable set of products to display. Kind Regards, Taylor Founder/Webmaster cell: 562-544-2355 office: 562-430-2829 AIM Y! MSN chat: loopwisechat http://www.loopwise.com - Collaborate With Other Musicians Online! Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.