Modification and fix to Prestashop

Work have to be done asap

Mostly this work is based on sql commands, but important to have experience with prestashop and its structure.

We have a Custom Import module already done but you need to recheck it and fix/add some functions.

There is a button named "upload a csv to database", it uploads the whole database into table called "ps_customimport_csv"



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 quantity

-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




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]



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

Skills: Database Administration, MySQL, PHP, Prestashop, SQL

See more: sql get date, wholesale and retail, sql commands, product upload prestashop, prestashop update, prestashop import, fix prestashop, custom orders prestashop, prestashop categories csv, update quantity prestashop, prestashop modify code discount, sql table remove, csv php prestashop, prestashop feed ftp, prestashop custom csv import php, prestashop cron import csv, ftp stock file prestashop, sql final, cron update csv prestashop, remove google tracking

About the Employer:
( 13 reviews ) Copenhagen, Denmark

Project ID: #4416759

1 freelancer is bidding on average $99 for this job


Lets Start Discussing it

$99 USD in 5 days
(19 Reviews)

Hello, we can handle this job, Regard.

$60 USD in 3 days
(10 Reviews)