Find Jobs
Hire Freelancers

Import from Ordermentum to Excel (Pablo)

$10-30 AUD

Mbyllur
Postuar almost 6 years ago

$10-30 AUD

Paguhet në dorëzim
Macro: ORDERMENTUM_IMPORT Purpose: To open a file exported from the ordering website and populate the the excel order spreadsheet with quantities matched to the product codes for matching customers. Pre-processing: Prior to populating the spreadsheet, a number of checks should be performed on the exported data. Any negative results of the checks should be communicated back to the user via a dialog box. Check 1: Check for Consistent delivery dates - All delivery dates should be for the same date and that date should be the date that is named in the worksheet title. If a negative result is found, the import operation should cease. The dialog box is to have the working "One or more delivery dates in the exported file do not match this worksheet. Please check the exported data." Check 2: Check for duplicates. If there are two instances of the same customer with the exact same order, the operation should be paused. The dialog box should bring this occurrence to the attention of the user with two options Continue or Cancel. Passing the above two checks, the import process can begin. If a filter is applied to the worksheet of interest (or Master worksheet) the filters should be removed. Consideration should be given to speed of the process. As with previous macros, it may be more expedient to separate the worksheet into its own workbook before populating. Process Checks: Whilst processing the data during the populating stage, the following checks should be carried out - Check 1: The "State" field should be checked (column D). If the state says "Cancelled", the data should not be imported. Any customers with Cancelled orders should be shown in the dialog box at the end of the import. Check 2: New Items - If an item exists in the import data that is not in the spreadsheet, the item code and description should be added to the appropriate section of the worksheet. The populated cell for that item should be highlighted in red. The item should also be added to the Master worksheet. It is important that the totaling formulas a tops of the columns are not broken with the addition of new rows. Consideration should be give to the case where the item code has a supplier prefix that is not yet present in the worksheet or master. This has caused a fail in the past. One way to handle would be to not import the item and show the details of item and customer in the dialog box at the end of the process. Check 3: New Customers - If a customer in the import data is not yet defined in CUST and Shortname worksheets, it should simply be added to a new column and highlighted in red. Details should show in the dialog box at the end of the process. Successful Import: At the end of the import, if nothing else to show in the dialog box, it should show the message "Import Completed Successfully". Amendment1: New customer - The new columns should be placed at the end prior to the BLANK column. The cell should not be highlighted in red but rather the same blue as the other column headers so it can be cleared and repopulated without accidentally doubling the data Amendment 2: When importing data into a cell, if the cell already contains data it should be cleared of it. However, if a data file contains two orders for the same item placed by the same customer e.g. a customer orders 1 loaf of bread and then realises they need 2 more so the place another order.. the populated cell should contain the sum of those items from the file.
ID e Projektit: 17214501

Rreth projektit

19 propozime
Projekt në distancë
Aktive 6 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
19 freelancers are bidding on average $50 AUD for this job
Avatari i Përdoruesit
Hello, I can help with you in your project Import from Ordermentum to Excel (Pablo). I have more than 5 years of experience in Data Processing, Excel, PHP, Software Architecture, Visual Basic. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$250 AUD në 1 ditë
4,9 (624 përshtypje)
8,6
8,6
Avatari i Përdoruesit
hello, Can you show sample files? exported file, populated file, any other revelant file I like to know the data structure, involved workbooks and its worksheets and columns. thanks, Ronald
$100 AUD në 7 ditë
4,9 (27 përshtypje)
5,0
5,0
Avatari i Përdoruesit
hello sir my name is mohamed i have experience in microsoft excel so you you will get your work quickly You will not pay anything without being satisfied from my work
$25 AUD në 1 ditë
5,0 (1 review)
0,8
0,8
Avatari i Përdoruesit
Respected Sir/Madam, I can do it very efficiently and taking care of it's purity prior to Web and Data scraping task. I work on projects as career more than a job. It's an opportunity for us to positively impact real outcome for every tasks as we help clients grow their business and we achieve our career goals. EXPERIENCE: I've successfully delivered many projects based on data scraping process. I scrap data using automation tools such as >iMacros (Basic code) >iMacros (Javascript) >WinAutomation >Quickmacro >C# and more.. As well as, I can scrap data manually if not possible to scrap using automation tools. I am still sure that you won't regret from our quality services as I have become more proficient in accomplishing the projects beyond its quality, standards. Approach to the Job: I am very much enthusiastic to submit a competitive proposal having more competitive freelancers and have much confident that you will appreciate my hard work & quality for your Web and Data scraping project. I am available to start working on the project right now. QUOTE Negotiable on project discussion. I am available to start right away so please consider my proposal and hire me soon to get started on this project. Looking forward hearing from you. Best Regards, PB
$12 AUD në 2 ditë
0,0 (0 përshtypje)
1,0
1,0
Avatari i Përdoruesit
I would like to go with your project and pls let me know if you are interested with my bid.
$35 AUD në 2 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I am deep
$25 AUD në 1 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
opening receiving total CT SDK CT RYK defect store total sdk sale ryk sale sdk ryk us 1250 27 80 107 133750 us 1250 40 43 83 103750 0 0 40 43 us 1250 US 1350 127 252 379 511650 US 1350 87 89 50 226 305100 0 0 87 89 US 1350 US1500 15 138 153 229500 US1500 35 33 68 102000 0 0 35 33 US1500 us800 40 40 32000 us800 4 32 36 28800 0 0 4 32 us800 COT500 106 101 207 103500 COT500 25 100 125 62500 0 0 25 100 COT500 KURT1000 18 151 169 169000 KURT1000 70 56 126 126000 0 0 70 56 KURT1000 KURTY1500 109 109 163500 KURTY1500 60 40 100 150000 0 0 60 40 KURTY1500 st 1500 30 16 46 69000 st1500 28 8 36 54000 0 0 28 8 st1500 ST1800 73 139 212 381600 ST1800 121 60 10 50 241 433800 0 0 121 60 ST1800 st2500 30 30 75000 st2500 9 8 17 42500 0 0 9 8 st2500 ST2200 181 181 398200 ST2200 27 17 44 96800 0 0 27 17 ST2200 trouser 54 54 64800 trouser 11 6 3 20 24000 0 0 11 6 trouser 396 1291 1687 2331500 517 492 60 1122 1529250 0 0 517 492 1009 THIS JUST SAMPLE I WORK ON STOCK INVENTRY SALE BALANCE SHEET COMPLETE PROGRAM ON EXEL
$20 AUD në 1 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i AUSTRALIA
ERMINGTON, Australia
5,0
16
Mënyra e pagesës u verifikua
Anëtar që nga korr 4, 2016

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.