Scope of Work
I currently am using a creloaded website that you can see at [login to view URL] .
I would like to use Prestashop 1.6. I need an import module to take the txt file my supplier provides and bring it into prestashop.
To get the file I go to [login to view URL] and give my username and password. I then save as the webpage to a txt file. Example file included.
These are the fields it contains.
SKU Reference Code
ProductDescription1 Short Description
SubModelDescription Not sure yet what this is
ShippingWeight Package Weight
Caliber New Txt Field
Velocity New Txt Field
Parentage Not Used
ParentSKU Not USed
MSRP Not USed
MAP Not Used
InStockDate Not Used
WNet USA COST
UPC UPC BArcode
I need to have a table that I can input a Duty tax for each category. Not all categories have duty and those that do will be a changing rate. This will be part of the cost that it needs to calculate
2 Txt fields will have to be created for the product. They must be prominently displayed at top or bottom of description. I am open to suggestions.
If Velocity is <366 (I need to be able to change this number) then set the product to inactive so it will not show up on the website.
If a product is new and is not in the current site then the image needs to be downloaded from the MainImageURL and put in the site were it goes.
If a category or Manufacturer does not exist then it will need to be added to the site also
I need to set Variable's before the import is done. In order to set the Canadian Cost price. (see jpg)
1) CAD exchange rate
2) Shipping Cost (all items)
3) Markup Cost * %
Wnet * Exchange Rate=CAD
Duty=(CAD+GST)*Duty that is set Variable
Sell Price= Cost*Markup
Once everything is done, I need a report to show what is new and added so I can check if the import is working.
Finally, I need the categories to be displayed on the left hand side of the main page so its easy for people to select the categories.
I am looking fro this to be automated. If there are any manual file manipulation on my part. Let me know in your proposal.
Let me know if you can do it in Prestashop 1.7.1 or do you recommend 1.6 ?
14 freelancere byder i gennemsnit $247 på dette job