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

Closed job

zarii 2 deals

GPT chat - search and paste data into excel.

Proposed by freelancer

31

14d

Good day, Excel covers about 100k records, for which I need an additional column of data, more precisely it looks like this: - Name - Brand - Missing data (code) So far, I have used GPT chat myself, returning one simple prompt + copy-paste column with Name and Brand. Out of 44 items sent back, the chat returned 43 items. The most important provision in the order refers to the following: The Contractor undertakes to execute the order with due diligence and in accordance with applicable regulations and requirements of correctness. Completion time: until 19.11
grucholl 6 deals

Entering car parts with translation from EN to PL - Prestashop

Proposed by freelancer

13

12d

I will outsource the input of various auto parts into a Prestashop store. I am looking for a person who has knowledge and experience of car parts and automotive and English language skills in this area. A person who knows the difference between a camshaft and a crankshaft or a stabilizer bar and a torque bar.... I have to introduce several hundred parts from the American market, which should be fully entered into the Prestashop store in Polish. I will provide part number, EAN code and product price. I will provide some catalogs where you can get information and pictures about the parts, but it may happen ( individual cases) that you will have to look for the information yourself. I ask in the offer to quote the price for running one item from the store.
Łukasz

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

Proposed by freelancer

32

22d

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

Finished

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