How to upload inventory for outside brands. SOP

Outside brands will send you inventory updates on a weekly, sometimes daily basis. We want to try and update this information as often as we possibly can, to ensure our customers are getting accurate information and to prevent the cancellation of orders due to them being out of stock. A majority of these outside brands will send these inventory updates to your Rustic email.

Google

4 Steps

Go to Inbox (7) - amarin@rustickitchenandbath.com - E-COM TEAM Mail

Please check your Rustic email every Monday, Wednesday, and Friday as this is when we want to upload inventory to ensure we are up to date.

Find the brand email with the inventory attachement.

Once you see the email with the inventory update attachment, open the email.

This is how the attachment should look. Download the attachment.

Click on Download attachment.

Tango

1 Step

From here, you will have to Export the attachment from the .CVS file to an Excel file so you can edit it.

Delete all the information other than the SKU, and inventory amount. They may be named as "Itemcode, Item number, available", please rename them as SKU, and Inventory. Please be sure to type it as "SKU" and "Inventory" as it is case sensitive.

Stock-sync

5 Steps

Go to Stock Sync

Click on Outside Brand Inventory Update… Do not touch Al's Sheet. Or else...

Drop your file here!

Once you drop the file in, it will begin to queue and update.

Once it has uploaded, this is how it should look. It will have a percentage of products uploaded, and the amount of out of stock varients.

If this is ever all 0's, you done messed up. This can happen if you misspelled something, or if you upload a Rustic file into TRHS Stocksync.

Well done!

Create how-to guides like this in a snap. Get Tango now.