Script to work with 2 excel files
$30-5000 USD
Betalt ved levering
You will work with 2 excel file. You will take values from the second file (item codes) and if found in the first file will set a particular column for this row/product to either 1 or 0 depending on the settings.
Delivery is within 2 days.
## Deliverables
We have a file with our products with many column such as description, title, itemcode, etc. 2 of the columns that you will be working with are: IsActive (values 0 or 1 in column A) and another column is C: ItemCode (which can be a combination of numbers and digits, for example ED-5877 or 103590, or AC1011, or 111, etc).
The second file (file 2) will have only 1 column: IteCode. You have to compare these 2 files.
Basically you take a value of ItemCode from file 2, find a row with this ItemCode in column C in file one and overwrite a value of IsActive (column A) in file 1 for this product based on the given settings/criteria.
Here are the settings for the script:
1. Set IsActive to 1 and for all not found products in file 2 IsActive should be set to 0 (that’s for the products that we actually have in stock, the IsActive will be set to 1 for those that we have in stock and to 0 for those that we don't have in stock).
2. IsActive set to 1 in the first file for found products in file 2 without paying attention to other rows/products. That’s for products that we will always have in stock.
3. IsActiveset to 0 in the first file for found products in file 2 without paying attention to other rows/products. That’s for products that got out of stock.
We have a lot of products/rows in the first file (about 5000) so the program should work with this many rows without a problem.
Thank you,
Denis
Projekt ID: #2934521