We require a standalone tool to import and export data fields for our shopping cart's my sql database
We have on online Pinnacle Cart site.
Our site It has a custom mod to apply advanced filters. There is no import / export function for this because it was never incorporated within the user tools.
We require a simple script that can import and export this data to and from the Advanced Filter Tables. .
We need to be able to update the filters in simple spreadsheet then have the data uploaded in the format th mysql uses
Example:
Productname1 has product id 4545 filter Blue and Large
Productname2 has product id 3465 and filter Red and Blue and Large
Our csv mus be readable to us but translate into Table identifiers used in the current advanvced filter.
It's pretty straightforward ofor a very experienced mysql programmer. The mod author tells us that standard mysql table manipulation will work fine.
Very important important to us is that it be very easy to access and/or modify existing and new filters.