Discussion Forum: Thread 325101

 Author: GorillaBrick View Messages Posted By GorillaBrick
 Posted: Aug 4, 2022 11:29
 Subject: Inventory Acquisition from another BL store
 Viewed: 103 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

GorillaBrick (954)

Location:  USA, North Carolina
Member Since Contact Type Status
Jun 16, 2021 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Gorilla Brick
Hey smart people of Bricklink, I recently purchased the inventory from another
BL store. That store has provided me with their BL XLM download file (which
is actually a .txt file) generated from the "download" link located on the BrickLink
site under the "Add Items to my Inventory" tab. I DON'T want to MASS UPLOAD
this inventory to mine as that will make my inventory pretty messy with duplicate
items, different prices on those items, bad inventory locations, etc, etc.

My question is how can I import the invxlm.txt file into a "Brick Store" spreadsheet
first, so I can confirm the data and make any necessary changes prior to adding
it to my store?

Note: I thought I could do it by first adding it to a new wanted list, calling
that list up in Brick Store and than importing that as inventory, but that didn't
work as the wanted list is throwing errors for duplicated items (i'm assuming
New and Used conditions). So, I need some help. How do you guys handle store
inventory purchased from another seller?
 Author: axaday View Messages Posted By axaday
 Posted: Aug 4, 2022 11:50
 Subject: Re: Inventory Acquisition from another BL store
 Viewed: 27 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

axaday (7302)

Location:  USA, Oklahoma
Member Since Contact Type Status
Jun 28, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Axaday
In Help, dwilson5511 writes:
  Hey smart people of Bricklink, I recently purchased the inventory from another
BL store. That store has provided me with their BL XLM download file (which
is actually a .txt file) generated from the "download" link located on the BrickLink
site under the "Add Items to my Inventory" tab. I DON'T want to MASS UPLOAD
this inventory to mine as that will make my inventory pretty messy with duplicate
items, different prices on those items, bad inventory locations, etc, etc.

My question is how can I import the invxlm.txt file into a "Brick Store" spreadsheet
first, so I can confirm the data and make any necessary changes prior to adding
it to my store?

Note: I thought I could do it by first adding it to a new wanted list, calling
that list up in Brick Store and than importing that as inventory, but that didn't
work as the wanted list is throwing errors for duplicated items (i'm assuming
New and Used conditions). So, I need some help. How do you guys handle store
inventory purchased from another seller?

I don't understand why it wouldn't be easier to mass upload it to a stockroom.
From there you'd be able to do a non-unique items search to sort things
out.
 Author: par016 View Messages Posted By par016
 Posted: Aug 4, 2022 11:57
 Subject: Re: Inventory Acquisition from another BL store
 Viewed: 25 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

par016 (7633)

Location:  USA, New York
Member Since Contact Type Status
Apr 30, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Boston Red Blocks
In Help, dwilson5511 writes:
  Hey smart people of Bricklink, I recently purchased the inventory from another
BL store. That store has provided me with their BL XLM download file (which
is actually a .txt file) generated from the "download" link located on the BrickLink
site under the "Add Items to my Inventory" tab. I DON'T want to MASS UPLOAD
this inventory to mine as that will make my inventory pretty messy with duplicate
items, different prices on those items, bad inventory locations, etc, etc.

My question is how can I import the invxlm.txt file into a "Brick Store" spreadsheet
first, so I can confirm the data and make any necessary changes prior to adding
it to my store?

Note: I thought I could do it by first adding it to a new wanted list, calling
that list up in Brick Store and than importing that as inventory, but that didn't
work as the wanted list is throwing errors for duplicated items (i'm assuming
New and Used conditions). So, I need some help. How do you guys handle store
inventory purchased from another seller?

Just go into BrickStore and click import an XML file, then select the txt file.
That should import it into BrickStore for you and you can manipulate it as needed
but uploading to BrickLink.

Don't forget when you add an XML file to BrickLink there are all kinds of
options like consolidating lots, merging remarks, keeping old prices, or updating
to new prices. You could also upload to a stockroom and manipulate it through
there. Good luck.

-Pete
 Author: ATCB View Messages Posted By ATCB
 Posted: Aug 4, 2022 12:00
 Subject: Re: Inventory Acquisition from another BL store
 Viewed: 31 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

ATCB (8049)

Location:  USA, Texas
Member Since Contact Type Status Collage
Apr 3, 2016 Member Does Not Allow Contact Seller
Buying Privileges - OKSelling Privileges - OK
View Collage Pic
Store: Around the Clock Bricks
Two options:

1) you can use the Bricklink upload option, just use the drop downs and say to
"consolidate lots by using" options and change to "old..." that will put the
overlapping items together and only create new lots for the items you do not
have in your inventory

2) You can open it in Brickstore:

File
Import
Bricklink XML
use the drop down to change the file type to (*)
select the txt file and open
Save as a brick stock file once opened.


In Help, dwilson5511 writes:
  Hey smart people of Bricklink, I recently purchased the inventory from another
BL store. That store has provided me with their BL XLM download file (which
is actually a .txt file) generated from the "download" link located on the BrickLink
site under the "Add Items to my Inventory" tab. I DON'T want to MASS UPLOAD
this inventory to mine as that will make my inventory pretty messy with duplicate
items, different prices on those items, bad inventory locations, etc, etc.

My question is how can I import the invxlm.txt file into a "Brick Store" spreadsheet
first, so I can confirm the data and make any necessary changes prior to adding
it to my store?

Note: I thought I could do it by first adding it to a new wanted list, calling
that list up in Brick Store and than importing that as inventory, but that didn't
work as the wanted list is throwing errors for duplicated items (i'm assuming
New and Used conditions). So, I need some help. How do you guys handle store
inventory purchased from another seller?
 Author: GorillaBrick View Messages Posted By GorillaBrick
 Posted: Aug 4, 2022 12:35
 Subject: Re: Inventory Acquisition from another BL store
 Viewed: 27 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

GorillaBrick (954)

Location:  USA, North Carolina
Member Since Contact Type Status
Jun 16, 2021 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Gorilla Brick
PROBLEM SOLVED: Thank You so much. I was able to open his .TXT in BrickStore
without any issue after updating to the latest version.


In Help, dwilson5511 writes:
  Hey smart people of Bricklink, I recently purchased the inventory from another
BL store. That store has provided me with their BL XLM download file (which
is actually a .txt file) generated from the "download" link located on the BrickLink
site under the "Add Items to my Inventory" tab. I DON'T want to MASS UPLOAD
this inventory to mine as that will make my inventory pretty messy with duplicate
items, different prices on those items, bad inventory locations, etc, etc.

My question is how can I import the invxlm.txt file into a "Brick Store" spreadsheet
first, so I can confirm the data and make any necessary changes prior to adding
it to my store?

Note: I thought I could do it by first adding it to a new wanted list, calling
that list up in Brick Store and than importing that as inventory, but that didn't
work as the wanted list is throwing errors for duplicated items (i'm assuming
New and Used conditions). So, I need some help. How do you guys handle store
inventory purchased from another seller?