| Discussion Forum: Thread 265349 |
|
 |
| | | Author: | bb1331025  | | Posted: | Mar 23, 2020 11:24 | | Subject: | Inventory XML - Spreadsheet Tool | | Viewed: | 77 times | | Topic: | Inventories | | Status: | Open | |
|
| Not sure if anyone has provided something similar, but I'm working on getting
my store setup & wanted a way to work with my inventory in Excel while also not
having to jump through a bunch of hoops to convert it into XML for upload. I
also didn't want to deail with converting Category, Color etc. to their numeric
values, so I created a spreadsheet that can deal with all that.
If you're interested, here's the link to my google drive folder where
the sheet is located.
https://drive.google.com/drive/folders/15FK6a5iTXPyy18O6emaGvIcG9mX17xmO?usp=sharing
Please let me know if you have any issues, feedback & suggestions are always
welcome!
Glenn
|
|
| | | | | |
| | | | | Author: | runner.caller | | Posted: | Mar 23, 2020 11:58 | | Subject: | Re: Inventory XML - Spreadsheet Tool | | Viewed: | 26 times | | Topic: | Inventories | |
|
| In Inventories, gboynt writes:
| | Not sure if anyone has provided something similar, but I'm working on getting
my store setup & wanted a way to work with my inventory in Excel while also not
having to jump through a bunch of hoops to convert it into XML for upload. I
also didn't want to deail with converting Category, Color etc. to their numeric
values, so I created a spreadsheet that can deal with all that.
If you're interested, here's the link to my google drive folder where
the sheet is located.
https://drive.google.com/drive/folders/15FK6a5iTXPyy18O6emaGvIcG9mX17xmO?usp=sharing
Please let me know if you have any issues, feedback & suggestions are always
welcome!
Glenn
|
Neat!
-I've got a similar spreadsheet for initial uploads that links the color
code to the typed color name.
-I'll often download by current inventory and then use a vlookup in the "Remarks"
column for the new upload so it'll return an inventory location if an identified
part/color combo already exists in inventory.
-Do you create the XML using that yellow "Upload" icon as a macro enabled button?
That'd be a handy short-cut I might have to add.
|
|
|
| | | | | | | | | |
| | | | | | | Author: | bb1331025 | | Posted: | Mar 23, 2020 12:09 | | Subject: | Re: Inventory XML - Spreadsheet Tool | | Viewed: | 19 times | | Topic: | Inventories | |
|
| Thanks for the feedback!
For this initial version, I didn't want to add any Macros just in case it
made people wary of downloading and trying it out, but I can absolutely create
a version that's macro enabled and add an export option/button linked to
a macro.
Right now, it's two steps, right click the data and export the xml, then
the Upload button just takes you to the Bricklink upload page so it can be uploaded
manually. I'd have to take a look at the upload HTML request / post detail
to see if there's a way to do it in a single button.
I'll take a look tonight. Thx again!
| |
Neat!
-I've got a similar spreadsheet for initial uploads that links the color
code to the typed color name.
-I'll often download by current inventory and then use a vlookup in the "Remarks"
column for the new upload so it'll return an inventory location if an identified
part/color combo already exists in inventory.
-Do you create the XML using that yellow "Upload" icon as a macro enabled button?
That'd be a handy short-cut I might have to add.
|
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | runner.caller | | Posted: | Mar 23, 2020 12:16 | | Subject: | Re: Inventory XML - Spreadsheet Tool | | Viewed: | 35 times | | Topic: | Inventories | |
|
| In Inventories, gboynt writes:
| | Thanks for the feedback!
For this initial version, I didn't want to add any Macros just in case it
made people wary of downloading and trying it out, but I can absolutely create
a version that's macro enabled and add an export option/button linked to
a macro.
Right now, it's two steps, right click the data and export the xml, then
the Upload button just takes you to the Bricklink upload page so it can be uploaded
manually. I'd have to take a look at the upload HTML request / post detail
to see if there's a way to do it in a single button.
I'll take a look tonight. Thx again!
| |
Neat!
-I've got a similar spreadsheet for initial uploads that links the color
code to the typed color name.
-I'll often download by current inventory and then use a vlookup in the "Remarks"
column for the new upload so it'll return an inventory location if an identified
part/color combo already exists in inventory.
-Do you create the XML using that yellow "Upload" icon as a macro enabled button?
That'd be a handy short-cut I might have to add.
|
|
Cool, also every time I export from my sheet, the first line of code is filled
with a bunch of garbage so I always type the first line manually
and then paste in the rest.
Any ideas on how to get rid of all that schema blah blah jargon when exporting?
|
|
|
|
|
|
|
|
USA, Illinois
