You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
NOTE: This post was created on 2022-11-22 on the Kryptronic eCommerce Community facebook page, which has been replaced with this forum. All facebook support content was migrated into this forum in April 2024.
Evan:
Does anyone have a suggestion for a spreadsheet header mapping utility or procedure that can be used to map data column headers over to table headers in K9 for bulk importing data? This is needed to prepare product data in a spreadsheet to be properly imported in the inventory items and product offers sql tables in the database. Thank you.
Graham:
If you look in system/ database/ raw database admin you can export the existing tables with their headers as a csv file.
If your existing data is already in table form, you should be able to copy and paste your current data over column by column.
Evan:
Thank you for your response. We are looking for a method to map the column headers and save the map for a particular spreadsheet so that we can save time with conversions and adding new products en masse. Thanks again 🙂
Kryptronic:
We typically write utilities/helpers that do this for clients. You upload a CSV file and it either updates the inventory, pricing and offers directly, or returns a properly formatted CSV file that could be uploaded using the Raw DB Admin utility. That would be a quick Custom Shop job, if you're interested.
Evan:
Does this give us the ability to save a new profile for each spreadsheet map? The spreadsheets come from different vendors and no two spreadsheets have exactly the same headers to map.
Offline