Work have to be done today, Another freelancer may already have done below fixes but her didnt answer for 3 days, so maybe the project is already done.
We have a Custom Import module already done but you need to recheck it and fix/add some functions.
Mostly this work is based on sql commands, but important to have experience with prestashop and its structure.
There is a button named "upload a csv to database", it uploads the whole database into table called "ps_customimport_csv"
(A) CUSTOM IMPORT MODULE
1 - Import Categories button
You have to modify the "import new categories button" so it reimport categories from the "ps_customimport_csv" table.
the category and sub category are the 7 and 8 value in the "ps_customimport_csv" table, import them and then relate to each product,
the product have to be assoseiated with both categories, the sub and parent caretgory. Products are already imported.
2 - Update Quantity button
The "update quantity" button currently does this job:
It update the quantity from the ps_customimport_csv table in the database, it also update the "wholesale price", but it doesnt update the retail price for the product, so it has to do that.
3 - Add discount button
The "Add disocunt" button uses uses another website to get discount
But it has also to remove the discounts if they no longer exsist.
in the final the "update quantity button have to do all these merged together
-update wholesaleprice and retail price by pricerange in percent
-search for discount and add/remove them if they exsist or not exsist.
4 - other buttons
There is already a
"Deactivate all products not in stock"
"Activate all products not in stock"
"Delete all products not in stock"
they dont work propapply
Note, all that have only to affect products from this supplier in "ps_customimport_csv"
5 - FEED
For the feed (already exsist)
have to be parent category and sub category
if there is no then the value have to be the EAN code instead
i need to add 'from=&kelkoo' to the end of the url to be able to have exact tracking og links in google analystics
(C) SEARCH FIELD
6 - SEARCH
Possibilties to let people search by 'product ID' & 'Supplier refrence' & Ean in the search field for both backend and front end. i think you will have to change the classes/[url removed, login to view]
(D) EXPORT ORDERS
7- JPS Mass Export Module
We already have this module.
This module allows you to export your shop orders as a CSV file for download, FTP or by CRON JOB + in earlier saved PROFILES
there is "Start date" and "End date" only, we need time function
example from "05-04-2013 17:00 clock" to "06-04-2013 17:00 clock"
and there is already cron job task into the module, so it has to automaticly genereate csv file to ftp for every day by cron job selecting daily report