In Progress

Bulk Upload Products to Store / Edit .CSV file

We need a Expert in Virtuemart to upload stock to our shop via Bulk csv upload or through PHPMyAdmin.

Only those that have done this before need apply.

We have around 8000 products that need uploading,

We have a CSV file with close to 32,000 records, the reason for this is for every 4 lines of records, 3 are duplicates.

So you will need to remove all duplicates from the CSV file. Most likely you can do this in bulk.

Also in the CSV file, the Categories are actually Sub-categories.

We will give you a text file list of the Main Level categories in which these Sub-Categories in the CSv file must go under before you upload.

You do not have to upload any images. We will do that.

You only have to prepare the CSV file correctly and upload the products to our store.

You must also edit the main/sub category to match the store category structure before entering it into the csv file otherwise duplicate categories will be generated.

Correct: category_path


Automotive/All Cars

Not category_path:


Automotive/ALL CARS

Also note the image file name is the actual SKU product code.


Image file name: [url removed, login to view]

SKU: A8178B-md

product_full_image: A8178B-md

product_thumb_image: A8178B-md

The excel file we will send you will contain the image file names like this per product: [url removed, login to view]

Its your job to remove the ( .jpg ) part and ad the balance ( A8178B-lg )as the SKU code for the product.

Image with a A8178B-lg-b ( b Extension ) are for black t-shirts, the b must not be removed.

We are stocking t-shirt into our store so have to be very careful in the image filenames.

eg: White t-shirts files are like these below:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

eg: Black t-shirts files are like these below:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

see the difference ( black has a b_ before [url removed, login to view] )

Total csv fields










The following dont require work, just same entry in all fields so copy and paste in bulk:

product_price (Entry 14.50 )

product_s_desc (Entry Small )

product_desc ( Entry main )

attribute ( Entry Attri )


The following will require you to work on accurately.






After you finish the Upload, we will run a script and insert the Additional Images, product prices, Small and Main Description and product Attributes in bulk.

All the information will be contained within 1 Excel file, you have to go through it and make the csvs correctly for uploading.

Here is the download link the the actual CSV file:

[url removed, login to view] Report - final - with [url removed, login to view]

Only bid if you are experienced in this type of work.

Maximum budget $100

Looking for someone to start right away.

Will pay right away on completion and great feedback for job well done !

Thank you

Skills: Data Processing

See more: type of data structure in c, type of data structure, t shirt categories, pay as you go stock images, md b file, make products, looking for duplicate data in excel, list of data structure, link list in data structure, lg com, job edit, it job titles, excel expert com, edit job, edit feedback, edit copy, data structure type, data structure through c, data structure note, data structure link list, black names, bulk product edit csv file, bulk upload products, bulk edit csv, upload bulk store

About the Employer:
( 25 reviews ) Osaka, Japan

Project ID: #200648

2 freelancers are bidding on average $90 for this job


Please check PM

$80 USD in 1 day
(3 Reviews)

Don't worry sir I got it. Lets start it.

$100 USD in 5 days
(0 Reviews)