In Progress

Data Collection - Strict Data Input

Hi,

I need to get an Excel .xls inventory of all the rings and images on my website from somebody who has worked on data import sheets before. It is important you understand data integrity rules and strict data type.

I have attached an example spreadsheet and an example of the image saves (they all need to be saved individually depending on what shape they are - rings including the stone with the corresponding description) with exactly how I need it. This needs to be started again.

Both the Excel sheet and the ring images folder needs to be collected. All full size images not thumbnails.

I need all items as they are in the sample sheet they are from the ring builder section on [url removed, login to view]

. It is important that the example sheet is followed. All single items need to be on a separate excel sheet.

Can you also please add an extra field with the original sku of the item - all old SKU number need to have sku ID + 4242 (eg. current sku 1324 new sku is 5566, image name should also be corresponding [url removed, login to view])

Please let me know of any questions.

Please send me the first 5 items so that I can make sure they are being done right, then I will give the green light to continue - if it is correct.

Important things to take note of -

1. _type attribute: should be 'simple' for all products

2. _product_websites: should be base

3. collection: should be respective collection on website

4. enable_googlecheckout should be '1' for all products

5. has_options should be 0

6. msrp_display_actual_price_type should have 'use config'

7. msrp_enabled should have 'use config'

8. options_container should have 'Block after Info Column'

9. required_options should have '0'

10. thumbnail should have image name

11. Visibility should have 4

12. _media_attribute_id should be 82

13. _media_image The ring images need to exist for all respective rings and stone types. so when you go into a product - then click on the 'round' cut diamond you have to save that file (FULL SIZE) for the image of the round ring. and do the same for each different ring stone type including ring and stone.

14. _media_is_disabled is missing.

15. Please follow all other convention in excel sheet.

16. Use template headers provided.

I have attached a copy of a working example - there are quite a few hundred items.

Follow the lead of the example please.

Skills: Data Entry, Data Processing, Excel

See more: what types of designers are there, what type of designers are there, what is data input, what do product designers do, website builder for designers, things you need to know that a important in excel, round name, how to get products designers, data processing and data base, data entry builder, 3 types of data entry, types of designers, data entry rules, when do i get a data entry done, spreadsheet input, sku inventory, product data sheet template, input products, input data jpg to excel, excel data input, data collection and data entry, sample data input, website input images product data, ring done, copy data excel website missing data

About the Employer:
( 2 reviews ) NO MAIL, Australia

Project ID: #2550992

Awarded to:

asyraf1156

Hi.. I can do this work for you.. Please see Pm.. THanks

$30 USD in 2 days
(56 Reviews)
5.6

5 freelancers are bidding on average $32 for this job

binaryromel

##### Experienced! Please check PM. #####

$35 USD in 1 day
(47 Reviews)
5.2
creatdesign

Experience expert, rather surpassing your expectations. Thanks.

$35 USD in 7 days
(6 Reviews)
1.8
jiveshsingh

ok sir. check pm sir.

$30 USD in 1 day
(4 Reviews)
0.0
dataprocessing1

Hi, Please see your PMB, important information regarding project.

$30 USD in 2 days
(0 Reviews)
0.0