Find Jobs
Hire Freelancers

Data Entry/Processing Macro

$30-250 SGD

In Progress
Posted over 11 years ago

$30-250 SGD

Paid on delivery
Simple task! Create a excel macro that translates data from [login to view URL] to [login to view URL] as attached. 1) In the [login to view URL] file, there are three headers. "attribute:a_caacity" carries information of the size and variations of the product name (post_title). 2) For every size and variations, a row must be created in the result file as shown in the [login to view URL] file. In the result file, you have to match the following columns in the [login to view URL] file to the result file: post_title -> Parent post_parent -> post_parent For all other product: attribute:pa_capacity -> meta:attribute_pa_capacity For skincare product: attribute:pa_capacity2_skincare -> meta:attribute_pa_capacity2_skincare 3) As you can see in the [login to view URL] file, under attribute:pa_capacity you see fields like 50ml|75ml|75ml TESTER. This field means that the product ANNA SUI DOLLY GIRL EDT FOR WOMEN comes in 50ml, 75ml and 75ml tester. In the result file, I need you to form 3 rows like what you see in the [login to view URL] file. 3 rows for the product with the post_title and post_parent mapped over (from [login to view URL] file), one row for each size. Note: If there is only one size, only 1 row is required for the result file. 4) Then input the size for the appropriate row in the column meta:attribute_pa_capacity in the result file. 5) Finally, I need manual data entry work from you to key in the prices for the respective product sizes. The result file will contain about 1800 rows. Please PM the result file if you can do it.
Project ID: 2634101

About the project

10 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See your PMB
$50 SGD in 2 days
4.9 (18 reviews)
5.1
5.1
10 freelancers are bidding on average $239 SGD for this job
User Avatar
Thanks for your invite. Please check your PM
$150 SGD in 5 days
5.0 (29 reviews)
7.2
7.2
User Avatar
----------------------------
$1,500 SGD in 3 days
5.0 (54 reviews)
6.2
6.2
User Avatar
Lets start..
$100 SGD in 1 day
5.0 (71 reviews)
5.3
5.3
User Avatar
Excel / VBA pro - ten years experience.
$100 SGD in 3 days
4.9 (25 reviews)
5.3
5.3
User Avatar
Expert Here. Please check P>>
$40 SGD in 2 days
4.8 (20 reviews)
4.1
4.1
User Avatar
Please Check PMB for details.
$100 SGD in 2 days
4.9 (11 reviews)
3.8
3.8
User Avatar
I have fully understood project details. I am built several scripts to automate the tasks. Let's start project.
$170 SGD in 2 days
5.0 (10 reviews)
3.7
3.7
User Avatar
The macro is ready in 4-5 houres , and depends the data to complete I think 2-3 days. Yo'll have ready Sunday if yo're agree. Just contact me :)
$100 SGD in 3 days
5.0 (7 reviews)
3.6
3.6
User Avatar
Sounds interesting!
$200 SGD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
dear sir, i think i can do your job well with good finish. thanks
$50 SGD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SINGAPORE
Singapore, Singapore
4.3
2
Member since Dec 26, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.