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/Airplanes

Automotive/All Cars

Not category_path:

AUTOMOTIVE/Airplanes

Automotive/ALL CARS

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

eg:

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

product_name

category_path

product_full_image

product_thumb_image

product_price

product_s_desc

product_desc

attribute

---------------------------

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

product_price (Entry [url removed, login to view] )

product_s_desc (Entry Small )

product_desc ( Entry main )

attribute ( Entry Attri )

------------------------------

The following will require you to work on accurately.

product_sku

product_name

category_path

product_full_image

product_thumb_image

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 data structure, shirt categories, pay stock images, looking duplicate data excel, link list data structure, job edit, edit job, edit feedback, edit copy, data structure type, data structure note, data structure link list, black names, bulk upload products, bulk edit csv, upload bulk store, csv bulk uploader, free csv uploader, editare csv, stock categories, md n, great job image, white balance, uploading products, upload

About the Employer:
( 25 reviews ) Osaka, Japan

Project ID: #200648

2 freelancers are bidding on average $90 for this job

swapneal

Please check PM

$80 USD in 1 day
(3 Reviews)
2.0
salamsamee

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

$100 USD in 5 days
(0 Reviews)
0.0