We require a secure webpage interface that will open in most browsers and connects to our online websites php / mysql back office and allow a file of products to be created or updated. Similar to Prestashops csv importer but more user friendly.
We have multiple databases (have same tables and structure) so need the ability to select the database to be updated
Need to be able to choose a local file for upload (predefined layout in ; or| delimited csv format)
The product name field within the file will need to validated and checked for any invalid foreign characters php/mysql will not except and supply list to be edited.
The products will NEED to be created using the table id (id_product) within the file if the ‘id_product’ already exists then the product will need to be updated with the information from the file.
Any blank fields within the uploaded file will not apply any changes to the corresponding online field within the tables, only fields with data populated will be created / updated.
File Field list
id_product ; Product Title ; Price ; Stock ; active ; id_tax_rules_group ; id_category_default ; All Categories ; Web Copy ; ean13 ; reference ; out_of_stock ; Media ;
Certificate ; Director ; Actors ; Distributor ; DVD Label ; Featuring ; Languages ; No of Discs ; Region ; Release Date ; Running time ; Subtitles ; Technical ; Tracklist ; Year
This is not an exclusive list and may require additional fields so need to ability to add to this list and still be able to update the table data.
File Format & Layout
Sample file attached
Optional to be quoted by awarded developer post initial module
Able to use several predefine file layouts can have set filenames if required and select type of update required from a list or button
Create New Products / Update Products Details / Update Product Prices / Update Product Categories / Deactivate Products (removes from website) & End of line Stock (prevents listed products being ordered when out of stock)
NB - All of these can be achieved using the above original interface.
View a list of products from selected database with a sort, search & filter ability to narrow down the list which displays the fields from the file layout and allows the ability to individually edit and update a selected product.