Data Feed for Wholesale Central on oscMax catalog

• Project ID:

  630794

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

I need a product datafeed pulled from the mysql database for my oscMax 2.0 RC3 store to submit to my Wholesale Central account once a week. The script doesn't actually have to sumbit the datafeed, I can do that manually, but it needs to generate it in a text file that I can download and re-upload to my Wholesale Central account when new products are added.

I previously hired someone else to set this up and I believe they modified a contrib for Froogle Data Feeder 1.62 (This feeder has been revised to work with Ultimate SEO URLs 2.1d - http://www.oscommerce.com/community/contributions,2823 - but it looks like they have SEO urls set to false) and renamed it feed_wc.php.

This worked for the first few months, but recently it stopped working. Now it just generates the column titles, but does not generate the actual products or any of their information.

After this was originally installed, I installed another contrib to force the customer to buy a minimum amount before they can check out, and may have inadvertently messed it up somehow. I'm not sure exactly when it quit working because I haven't tried to generate a feed in the last month. I know it was working before that.

I need someone to track down the problem and fix it. This site is heavily modded.

Instructions for the Wholesale Central Data Feed:

Your data feed must be a tab-delimited text file. You can create a tab-delimited text file using a spreadsheet such as Microsoft Excel, or export one with most any database or shopping cart program.

Your data feed file can contain up to 10,000 items. Each item in your data feed must have the following pieces of information in order:

Product URL
Product Name
Product Description
Image URL
Product Category
Product Price
For example, if you are using a spreadsheet, each row of the spreadsheet represents one item. Your spreadsheet will have six columns, one column for each of the pieces of information listed above.

Detailed information on the data feed fields:

Product URL - (required) The complete web address for this item. Product URL can have a maximum of 200 characters.
example: http://www.abc.com/store/item01.htm

Product Name - (required) The name of the product. This must match the name on the Product URL page. Product name can have a maximum of 100 characters.

Product Description - The product description. Must match the description on the Product URL page. Product Description can have a maximum of 300 characters.

Image URL - The web address for the image of this product. This must be the image that appears on the Product URL page. Image URL can have a maximum of 200 characters.

Product Category - If your storefront has product categories, then enter the product category for this item here. Product category can have a maximum of 50 characters.

Product Price - (required, unless the store is password protected) Must match the price on the Product URL page listed above. Members with password protected shopping carts can leave this field blank.(MINE IS PASSWORD PROTECTED) Product price can have a maximum of 50 characters.

Skills required:

MySQL, OSCommerce, PHP, Troubleshooting