Pro Help: Combining multiple supplier CSVs into a uniform CSV output file

Hire a Pro
1

Hi Community,

I’m working on a scenario that will ideally achieve the following import, data sort, aggregation, and export task.

Instructions:

  1. Fetch four different supplier CSVs from four different folders on the same FTP.

  2. Collect EAN, price, stock, title and supplier name from each CSV (column names and locations differ on each file, so may need to be assigned manually).

  3. A duplicate EAN search is then needed across all CSVs. If multiple suppliers are selling the same EAN, the module should assign the cheapest supplier’s pricing and stock to the aggregated output file (and exclude other suppliers that share the same EAN). This task is not necessary for duplicates within the same supplier file.

  4. The uniformly structured, aggegated file should then be uploaded to a specific folder on the FTP directory.

Many thanks in advance for any help/ advice!

1 Like
2

Hello @A_H1, I can help you with that you can book a call Here to discuss the project requirements and you can checkout my upwork profile Here

3

AH, chances are, you probably want to use a database in the middle.

In any case, we can help. Let’s meet on Zoom to go over the details. Book a time of us here https://connex.digital/book/make

Talk soon!

4

Hello @A_H1 I would be glad to help you reach out to me at Calendly - Dr spark
Let’s discuss the way forward

5

Hey @A_H1,

Do you have FTP directories to get and post files?

I would recommend building the process using the data storage module. to store data there and perform the checks that are needed. If this is cost-inefficient, you can use any other data storage service, like Gsheets or Airtable. and form there you can extract your data results and upload them on your server.

I am developing in live conversation so you can learn how the process works, and also, at the end of the conversation, you get your solution. Happy to schedule a 30-minute meeting with no commitment to share my thoughts in your exact process. Here is my calendar link: Solve it in 30 mins | Dimitris Goudis | Cal.com

Thanks
Dimitris Goudis | 3Nuggets

6

Hi @DimitrisGoudis

We have an FTP with file folders for each supplier, as well as a merged file folder for the output file.

Keen to understand more, so i’ve booked a call.

Thanks

7

This topic was automatically closed after 30 days. New replies are no longer allowed.