Skip to main content
R
Richard-Victorian-Novels
March 7, 2023
Question

Amalgamating Stock at Migration

  • March 7, 2023
  • 1 reply
  • 0 views

I am a secondhand/antiquarian bookseller, currently using Desktop 2021. I have a long list of stock items (thousands) from 20 years of business. Most of them have only been used once. If I try to amalgamate items (by changing the names and merging) I get a warning that this will affect historical transactions etc, so it is something I rarely do.

 

However, I am about to migtrate to QB Online. As I understand it, if I use MoveMyBooks to migrate, stock information with NOT be migrated, and it looks as if I will have to add this information manually after migration. Is this correct?

 

If I wanted to continue as before, this would be a huge problem, involving hours of work, relisting each item

 

But what I actually want to do is make my life simpler for the future and start afresh with just have one stock item -- "Book" --, using the total number and average price from my current Stock Valuation Report on QB desktop to set this up. That is to say, instead of, say 1000 different items all with different purchase prices/COGS, just 1 item (x 1000) with the average price.

 

Is this possible? Am I thinking in the right way?

1 reply

Fiat Lux - ASIA
Fiat Lux - ASIA
March 7, 2023

Another option, you may consider purchasing a 3rd party conversion service. We bring inventory details like name, code, description, sales account, purchase account, sales price, purchase price etc. Since the conversion doesn’t do tracked inventory, as part of the migration, we import all the items as "non-inventory" type in QBO and after the completion of the migration, you need to manually change the type from 'Non-Inventory' to 'Inventory' and add the quantity on hand manually for each item. Your historical data will remain intact.

R
Richard-Victorian-NovelsAuthor
March 7, 2023

That is precisely what I DON'T want to do.

Terms & ConditionsAccessibility statement