Find Jobs
Hire Freelancers

Import from Ordermentum to Excel (Pablo)

$10-30 AUD

Zaprt
Objavljeno pred skoraj 6 leti

$10-30 AUD

Plačilo ob dostavi
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 projekta: 17214501

Več o projektu

19 ponudb
Projekt na daljavo
Aktivno pred 6 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
19 freelancerjev je oddalo ponudbo s povprečno vrednostjo $50 AUD za to delo
Avatar uporabnika
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 v 1 dnevu
4,9 (624 ocen)
8,6
8,6
Avatar uporabnika
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 v 7 dneh
4,9 (27 ocen)
5,0
5,0
Avatar uporabnika
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 v 1 dnevu
5,0 (1 ocena)
0,8
0,8
Avatar uporabnika
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 v 2 dneh
0,0 (0 ocen)
1,0
1,0
Avatar uporabnika
I would like to go with your project and pls let me know if you are interested with my bid.
$35 AUD v 2 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
I am deep
$25 AUD v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 1 dnevu
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava AUSTRALIA
ERMINGTON, Australia
5,0
16
Plačilna metoda je verificirana
Član(ica) od jul. 4, 2016

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.