[Jim Icenhower]

I’m a programmer so the VBA stuff is easy for me. Might be hard to explain to everyone. My real difficulty was that I combine “one from column a and one from column b” to create a SKU. So a spreadsheet (or grid) in Excel works well with a different SKU in each cell at the intersection of the column and the row. I’m extremely happy with the result but it would not have been very useful without SixBit’s ability to import.

[Jim Icenhower]

I did something much like you suggested. I keep a master list of inventory in Excel and created a VBA script to create an Excel file I can import into SixBit. The VBA creates the combination of images based on some logic that looks at the components of the kits and creates that list in the file to be imported into SixBit. Since it uploads the same pictures many times it would be nice to predefine a set and just refer to the set in the import but this does work just fine.

Thanks!

[Jim Icenhower]

Thanks! I only changed a snippet which didn’t trigger an update of running listings but because it is used in a wrapper I just edited the wrapper to trigger the update.

Thanks again!

[Author]

Posts