Project Detail

Excel Macro For E-Commerce Product Upload  

Excel Macro For E-Commerce Product Upload is project number 481776
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: agihcam

Budget: $30-250

Created: 08/03/2009 at 12:14 EDT

Bid Count: 19

Average Bid:
$ 46

08/05/2009 at 12:14 EDT

Project Creator: samsonwebdesign
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (2 reviews)

Bid On This Project
 

Description

I need an Excel macro written to automate the product price updating on an e-commerce site.
We currently have 2 spreadsheets.
SPREADSHEET 1 - The first has the product code and the type of product.
SPREADSHEET 2 - The second has the product code and the cost price of the product.

What needs to be done:
step 1.
Sheet 1 needs to be matched against sheet 2 by product code and if the codes match the price from sheet 2 needs to be copied from sheet 1 and the row deleted from sheet 2.

step 2.
Sheet 1 now needs to copy any product codes that do not have a price next to them to another sheet and delete them from sheet 1.

step 3.
Multiply the price in sheet 1 depending on the product type and cost price.
e.g. IF type 1 AND < £30 MULTIPLY by 25%
These multipliers will be in a sheet within the main spreadsheet and the macro needs to run through every product and just apply the muliplier relevant to that product type and price bracket.

If any of this is unclear please PM me for more information.
We will supply spreadsheet examples to work on obviously.

Messages Posted:2 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

50

2 days

08-03-2009 12:22 EDT

Hi, please view my PM for details, thanks.

help

 

30

1 day

08-03-2009 17:36 EDT

I am a VBA expert. I have very good experience with Excel VBA. I have completed many projects in Excel skill. I will provide quick & professional service.

help

 

50

1 day

08-04-2009 01:44 EDT

Hi - I would be glad if you can show me a sample. Please check your PM for more information.

help

 

30

1 day

08-03-2009 12:34 EDT

Hi Please refer to PMB for details

help

 

30

1 day

08-03-2009 18:41 EDT

I will be happy to apply my 12+ year experience with programming for Excel to solve your problem. Please see more details in PM.

help

 

30

2 days

08-03-2009 13:07 EDT

You better check PMB.

help

 

30

0 days

08-04-2009 07:10 EDT

Please refer to PMB.

help

 

30

1 day

08-03-2009 21:37 EDT

Please refer to PM

help

 

201

5 days

08-04-2009 04:18 EDT

Hi, Please can you refer my PM.Thanks.

help

 

30

1 day

08-03-2009 13:44 EDT

Hi, View PMB for details Kris

help

 

30

0 days

08-03-2009 15:42 EDT

Your search ends here. Best provider. Select us and experience the difference.

help

 

30

1 day

08-04-2009 02:21 EDT

Please check PM for my offer. Thanks

help

 

50

2 days

08-03-2009 12:28 EDT

(No Feedback Yet)

I could do this sucessfully I have experience in a similar project please see my example

help

 

40

2 days

08-03-2009 12:34 EDT

(No Feedback Yet)

Can do this job. Please check PM

help

 

30

10 days

08-03-2009 17:04 EDT

(No Feedback Yet)

i have done an advanced course in excel and i get assure you that your demands will be fulfilled by my services

help

 

30

2 days

08-04-2009 02:34 EDT

(No Feedback Yet)

Hi, please see PM for detail. Thank you.

help

 

39

2 days

08-04-2009 03:01 EDT

(No Feedback Yet)

Mission Data Entry Services provides exclusive and highly accurate data entry and data processing services from India with absolute confidentiality and high level of accuracy. We offer data processing outsourcing and data entry from India for all kinds of textual data capturing from printed matter, manuscripts, scanned images, and web research. Data conversion services are offered with 99.99% accuracy from various file formats and medium to another. Benefits of Outsourcing to Us Data Entry India undertakes to deliver high levels of satisfaction by providing outstanding services, which span areas related to data entry, conversion, keyboarding, data capturing, coding, typesetting, document scanning and indexing. › Experienced professionals having various skill sets and well recognized Information technology skills › Experience of handling in excess of 100 projects › Competitive prices with no compromise with quality approach › Ability to quickly understand client requirements › Flexible project cost options - Fixed price OR Hourly price › Completion of project within specified time frame and budget › Experience of communicating and working with global clients › Transparent approach and long term relationship Client Satisfaction Data Entry Services has helped almost 50 of its valued clients in the past and can help you save 40% or more on your back office costs with assured satisfaction. We have the proficiency to deal with your outsourced needs within specified time period. You can expect a little more from us than while dealing with similar offshore companies. One of our foremost objectives is to help our clients to achieve their business goals at low prices. We will be of assistance to you to generate more income, margins and profits - Data Entry Services India: Data Entry India, Outsourcing Data Entry India Regards karthick

help

 

60

5 days

08-04-2009 03:46 EDT

(No Feedback Yet)

I am already working as a PREMIUM writer on some other freelance website, therefore, I am very much fimiliar about how to manage my task so that they are completed within time range, provided the complete satisfaction of the customer. So, I request you to please give me a chance and I assure you that you will ask for my service even in your future work.

help

 

50

2 days

08-04-2009 06:59 EDT

(No Feedback Yet)

I've done VBA macros for a research project with a local university. The macro can be done in 2 days. Payment can be made after delivery of macro. Check pm for more information.

help


    Bid on this Project