Please Note: our site contains adult content, bidders must be ok with and legal to work with adult content.
We're running Magento 1.4.2 Community edition. We need a script or module that can be set on a schedule to export a .csv file of our products as a feed for other clients. The client has a specific set of things they need, will be detailed below. Also, the file should be overwritten each time it's created rather than new file each creation. Script and process must be easy for us to learn and customize/edit/run any time we wish to.
We generate a product feed(list) in pipe-delimited text file (csv) of all our products under 2 different attribute sets only with other specific attributes requested by our client.
ID(SKU)|MOVIETITLE|STUDIO|RELEASE DATE |FORMAT|PRICE | PRODUCT URL
59086|DVD Name| Studio Name | 2011-07-15 | DVD | 9.99 | [url removed, login to view]
MOVIETITE= Product Name
STUDIO= Category attached: Adult DVD/Studios/"Name" Not sure how this can be accomplished but all products will have a category attached under that.
RELEASE= Release-Date of the product, some will have it some don't.
FORMAT= They will all be "DVD" format unless the product has category "ID: 65" associated with product then will Be "BLU"
PRICE= Product Price, if product has "Special price" attribute (sale?) then it needs to use that.
URL= URL will be in the form of the example file (editable later on).
We also need to be able to add additional columns to the export ourselves later on after the project such as UPC code, etc.
I have 2 example files (.ods and .csv) that I can PM to for further details.