Excel bamboozelry
I have searched high and low and have not found a great answer. Maybe someone here can assist?
The low-down:
CSV file database export with category names from my ecommerce site.
column 1 (Name) column 2 (ID)
super soakers 153
shoes 188
bottles 297
CSV file import file
column 1 (ID) column 2 (product name)
super soakers Big Super Soaker
shoes Black shoe with no laces
bottles Jim Beam Bottle
The need:
I need for file 2 (the import file) to know and change the value of column 1 to be the value of column 1 in the file 1 (export file) so that the 5k products that I have with over 200 categories can be done in one quick swoop.
ideas?
I'm willing to create random columns with the column 1 and 2 from file 1 into file 2 just so I dont have to search in other sheets or files.
The outcome (import):
column 1 (ID) column 2 (product name)
153 Big Super Soaker
188 Black shoe with no laces
279 Jim Beam Bottle
Subject
Views
Written By
Posted
Excel bamboozelry
1727
November 14, 2012 08:39PM
831
December 07, 2012 04:03PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.