Can I import inventory to another account and make changes to that inventory from another account?

The title of this thread has been edited from the original: Importing

 

My aunt and I have a store that has a walk thorugh so customers can go from one side to the other. We are running 2 different square accounts in each store but want to be able to check customres out on each side, Are we able to import into existing account with inventory and then continue to do so with updates on inventory change and inventory being added ? 

1,420 Views
Message 1 of 2
Report
1 Best Answer

Best Answer

Yes,  you can export inventory from one account and then import import it to another store.  However you will have to edit the spreadsheet once you export it before you import it to the other store because some of the data will not work from one store to the other.

 

To export your inventory items go to your online Dashboard / Items  - On the right side top corner Click "Actions" botton.  Then select Export Library. Either format works.  

 

I would export your inventory from both locations.

 

Now open your exported spreadsheet(s) in you favorite program, Excel, Google Sheets, Apple Numbers.

 

Move the data from one spread sheet to the other.  For new items copy these Columns - Item Name, Description, Category, Sku, Variation, Price.   Now the Current Quantity column you  want to paste it into the correct Column of the other store.  If you have more than one location make sure it is pasted into the correct location.  You will want to add it to the New Quantity Column so it adds it.

 

Note Don't Copy the Token as they are unique to your store and will be auto assigned for new items.

 

To update items that are currently in both stores you are just going to have to edit the New Quantity column in the spreedsheet by finding the item in the list.  If you sort both of them by item name it may make it easier.

 

I would also put all of her items in the same Category, This way you can pull a Category report and see what you sold of hers.  It will be hard to figure any Credit card fees.

 

Once you are done editing the spreadsheet you can upload it by going back to Item - Click the Action Button and Import Library.  Make sure you select modify...

 

 

 

 

View Best Answer >

1,414 Views
Message 2 of 2
Report
1 REPLY 1

Best Answer

Yes,  you can export inventory from one account and then import import it to another store.  However you will have to edit the spreadsheet once you export it before you import it to the other store because some of the data will not work from one store to the other.

 

To export your inventory items go to your online Dashboard / Items  - On the right side top corner Click "Actions" botton.  Then select Export Library. Either format works.  

 

I would export your inventory from both locations.

 

Now open your exported spreadsheet(s) in you favorite program, Excel, Google Sheets, Apple Numbers.

 

Move the data from one spread sheet to the other.  For new items copy these Columns - Item Name, Description, Category, Sku, Variation, Price.   Now the Current Quantity column you  want to paste it into the correct Column of the other store.  If you have more than one location make sure it is pasted into the correct location.  You will want to add it to the New Quantity Column so it adds it.

 

Note Don't Copy the Token as they are unique to your store and will be auto assigned for new items.

 

To update items that are currently in both stores you are just going to have to edit the New Quantity column in the spreedsheet by finding the item in the list.  If you sort both of them by item name it may make it easier.

 

I would also put all of her items in the same Category, This way you can pull a Category report and see what you sold of hers.  It will be hard to figure any Credit card fees.

 

Once you are done editing the spreadsheet you can upload it by going back to Item - Click the Action Button and Import Library.  Make sure you select modify...

 

 

 

 

1,415 Views
Message 2 of 2
Report
This thread has been archived and locked. Please start a new thread if you would like to continue the conversation.