Order to automate the import of customer order data into an Excel database

Closed job

Biuro Zleceń

Improving the invoice template in excel

Proposed by freelancer

27

24d

Hello, I am looking for a person to develop an invoice for me in excel so as to block individual cell changes. The invoice is ready in excel, only the relevant cells need to be blocked in such a way that the data cannot be changed.
Karol

Excel - generate SKU combinations

Proposed by freelancer

23

13d

I urgently need someone proficient in Excel who can generate the names of goods based on rules, e.g. XX-YYY-ZZZ, where X = 1 v 2 v 3, Y = A v B v C, Z = 0 v R, i.e. I provide the logic for creating the names, and I need them generated.
Łukasz

Excel - working on a worksheet, formulas, data, etc. (sports statistics)

Proposed by freelancer

33

2d

I am looking for a person who will make me formulas from Excel data (VBA or other simple possibilities come into play). The Excel data is already prepared. In the future I will want to supplement the file with new data. In short, from the data that is already in Excel I want to flirt data according to my needs. E.g. averages/totals number of goals/cards/penalties of a team in a season, a year or in the last 5,10 games, etc., further after selecting "team" from the list I will see the statistics of a particular team. Then comparing 2 teams I add for example Arsenal vs Liverpool and it shows stats: team vs opponent from last matches, season etc. (I can choose from how many recent matches it should show). In general, I am open to suggestions, ideas and help to make this clear and functional. I will try to give more details, information or questions on priv. I am looking for a person for whom doing such things will not be a problem and maybe will offer his vision of how it can be done practically etc., because I unfortunately do not know the functionalists of Excel so as to use it 100%. Interested persons please contact me. Remuneration to be determined. In general I am open to suggestions, ideas and help to make it clear and functional.

Łukasz Nowakowski

Employer

1 deal

Job category:

Databases

Expected budget:

Negotiable

Published: on 2024-04-08

Valid until: on 2024-05-08

Job description

I will outsource the task of automating the import of customer order data into an existing Excel database and assigning the appropriate data for new items from orders based on the existing database.

Details:

1. downloading the data from a csv file that will be updated once a day and uploaded to an FTP server from the client.

2. Putting the data into an Excel "Database" file by searching for a unique commodity code and assigning individual values to it from the following columns: order number, quantity ordered, date, place of delivery and price.

(3) The rest of the information assigned in the database for new items and the individual commodity code (ITEMID) should be invariable such as packing patterns, pallet dimension, number of pieces per pallet, labels, etc. and taken from this database.

4) Each new order should add itself as a new line in the file, without deleting previously added orders with the same item.

and more