Prestashop Supplier import with widget
Budget: $250 – $750 USD
I need a module for my prestashop site. The store is currently running 1.6.1 and as part of this requirement it must be upgraded to the latest version first. I can download from my supplier a .CSV file that will populate my products. I need the module to compare the CSV file to current products and make changes to reflex the current product state of the CSV file. There is also a small widget that has to appear on the website if the category for that product is selected. I have a current module that does these things that you can refer to but once yours is ready I want the old one not to show from the back office anymore. MY budget for this is around $250 USD.
Adding the CSV File(fig 7)
A top section that will allow me to browse for the CSV file and then add to module.
Input Section (fig 1)
In the input section. I need the following fields.
-Exchange Rate
-Markup Cost
-Velocity Setting ***
-GST Amount
-Canada Tax Rule
-Exclude Keywords ***
*** Velocity Setting. There is a field in the SCV file called FPS. IF the FPS value is less than< then do not import. If the FPS field is blank, then import.
*** Exclude Keywords. I need a text field that I can keep adding to where I can press an execute button and any product that has even part of a match in the description field will be set to not be show as an active product.
Calculating cost and selling price.
The CSV file that is going to be inputted also has a cost field. We need certain values in a formula calculated to give us our imported cost and selling price.
Wnet * Exchange Rate=CAD
CAD*1.05=GST
Duty=(CAD+GST)*Duty that is set Variable
Shipping=Set Variable
Cost =CAD+GST+Duty+Shipping
Sell Price= Cost*Markup
Category List and Settings (fig2)
As part of the module, I need to set some parameters that will be applied to the entire category. One of which is required for calculating cost. The CSV file does not include product sizes so I have to input and set the entire category W,L,H .These parameters are
-Duty(part of the cost)
-Shipping (extra shipping costs, is part of the cost)
Width
Length
Height.
Widget *
Start the process (fig3)
A Button to start the change process. IT needs to show live updates with this information
-Rows processed Qty of Total to do. I.e 403/4302
-Products Created
-Producst excluded (from our exclude field)
-Categories created. If the category does not exist then create it
-Manufacturers Created. If the manufacturer does not exist, then create it.
If it is a new product then one of the fields in the CSV file is the location of the image for that product. That will need to be downloaded and put in the product.
At the bottom of the module once the import is done, I need a display of the new products created showing the following
Part#
Short Description
Category (sort by category)
FPS (if there is info in that field)
Widget (fig 4 and fig5, fig6)
I need on the website a way to search for products in a category based on FPS. General I only use 2 categories Air Guns and Air Pistols. The 2 values I need search on which I want to be able to change is. In the module I will need enter the calibers available that can be searched on (1) or it can be search by (2) or (3).
1) Caliber FPS
2) 366 FPS- 499 FPS No Pal
3) 500 FPS- 1600 FPS Pal Needed
Adding the CSV File(fig 7)
A top section that will allow me to browse for the CSV file and then add to module.
Input Section (fig 1)
In the input section. I need the following fields.
-Exchange Rate
-Markup Cost
-Velocity Setting ***
-GST Amount
-Canada Tax Rule
-Exclude Keywords ***
*** Velocity Setting. There is a field in the SCV file called FPS. IF the FPS value is less than< then do not import. If the FPS field is blank, then import.
*** Exclude Keywords. I need a text field that I can keep adding to where I can press an execute button and any product that has even part of a match in the description field will be set to not be show as an active product.
Calculating cost and selling price.
The CSV file that is going to be inputted also has a cost field. We need certain values in a formula calculated to give us our imported cost and selling price.
Wnet * Exchange Rate=CAD
CAD*1.05=GST
Duty=(CAD+GST)*Duty that is set Variable
Shipping=Set Variable
Cost =CAD+GST+Duty+Shipping
Sell Price= Cost*Markup
Category List and Settings (fig2)
As part of the module, I need to set some parameters that will be applied to the entire category. One of which is required for calculating cost. The CSV file does not include product sizes so I have to input and set the entire category W,L,H .These parameters are
-Duty(part of the cost)
-Shipping (extra shipping costs, is part of the cost)
Width
Length
Height.
Widget *
Start the process (fig3)
A Button to start the change process. IT needs to show live updates with this information
-Rows processed Qty of Total to do. I.e 403/4302
-Products Created
-Producst excluded (from our exclude field)
-Categories created. If the category does not exist then create it
-Manufacturers Created. If the manufacturer does not exist, then create it.
If it is a new product then one of the fields in the CSV file is the location of the image for that product. That will need to be downloaded and put in the product.
At the bottom of the module once the import is done, I need a display of the new products created showing the following
Part#
Short Description
Category (sort by category)
FPS (if there is info in that field)
Widget (fig 4 and fig5, fig6)
I need on the website a way to search for products in a category based on FPS. General I only use 2 categories Air Guns and Air Pistols. The 2 values I need search on which I want to be able to change is. In the module I will need enter the calibers available that can be searched on (1) or it can be search by (2) or (3).
1) Caliber FPS
2) 366 FPS- 499 FPS No Pal
3) 500 FPS- 1600 FPS Pal Needed