Closed

Prestashop data import conversion

This project was awarded to Datasphere0 for $80 USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $250 USD
Total Bids
17
Project Description

Only bid if you know Prestashop. No bids will be considered unless you know Prestashop

I get a txt file from my supplier on a regular basis. I need certain columns copied to a new spreadsheet and others added to complete a Product import.

-I need two columns caliber and velocity concatenated to the begging of the Description column from the txt file

- Any record that has qty =<0 should be delete

-Any record that has a Wnet price of 0 or blank gets deleted

-I need some input questions in order to calculate the selling price. Take the field Wnet and ask these questions

1)What is the shipping cost? S

2)What is the Exchange rate? E

3)What is the markup? M

so in the end the field will be calculated like this

(wnet+S)*E then *M

Strip the info from the txt file that will case import problems like ; , &quot

I then need 2 CSV files created. 1 for Product import and 1 for Category Import.

Finally because the file will be large I might have problems importing them. It would be nice to be able to split the file up into several, maybe ask how big each file should be.

I have provided the TXT file and products XLS file so you can use as a guide.

If you are a good programmer and know Excel and Prestashop this should only take you a few hours. Bids over $100 will not be considered. I am running on a MAC so everything must be MAC compatible.

-

Awarded to:
Skills Required

Browse Related Skills

Related Projects

Other things people do on Freelancer

Related Articles

Latest Articles

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online