D
D
Dmitry2018-07-31 11:11:03
openoffice
Dmitry, 2018-07-31 11:11:03

Is it possible to find differences in two .csv files using OpenOffice?

Hello. When administering the store, I encountered the following problem: I need to periodically import the store's products on Woocommerce to the deal.by marketplace. But the bottom line is that the list of goods changes, and the fields that are exported from woo differ from those that are present in the deal.by import file, and csv files must be edited manually. For convenience, I upload a list of products already uploaded to deal.by, and here the problem arises: how to compare two files so as not to upload the same products back to deal.by, but upload only those that were not there or those that whose parameters have changed (mainly price or availability). If anyone has worked with this site - tell me how to get around the difficulty, or how to compare two .csv files and get the resulting difference file. There are more than 4500 positions in the market.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
sim3x, 2018-07-31
@sim3x

bash
sort
diff

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question