All things Shopify and commerce
I use stocky for receiving inventory. How do you do returns to the suppliers? For example, they send wrong product, etc and you have to send back. There would be shipping charges, etc that need to be recorded and inventory removed from system. I tried doing stock adjustments but it doesn't record any shipping costs nor does it assign to the vendor. It makes it very difficult to keep track of what I owe the supplier for goods. Any help would be appreciated. I looked in the community and there was nothing on any of the boards that I could find.
I am wondering the same thing. Did you get help from support on this?
No I did not. They had no clue what I was talking about.
So we now do it in stocky as a -1 for the item and put the RA in the invoice section.
I seems that it you put the -1 in stocky it it does not take the inventory out of Shopify. Is that correct?
We are not doing our invoicing through Shopify so it seems useless to do this.
I'm also wondering ho to do this. it seems strange there would be no function for this?
Anyone get any answers?
My work around is working in stocky. I do a purchase order and do a negative amount and receive the negative amount and put the RA number in the invoice section.
Sad that they still haven't addressed this issue 3 years later.
Hi -
I'll share the details of how I'm managing this, it's the most efficient and audit-proof method I can develop without actually developing a new app. For context, this process works for a $100M rev CPG company.
Create an adjustment with STOCKY (app)
Scan the barcodes of the items into a CSV excel sheet (barcode or SKU, negative quantity)
Import the CSV file with the SKUs and Quantities (negative values) that you are returning to vendor/warehouse/supplier etc.
Once populated, create a reason code (RTV - *supplier name*).
Assign an (sample: dd_mm_yy_Supplier001) RTV# in the Notes section, or if you have an ERP system that is accepting the "Return PO" it will auto-assign an RTV/RA # that you can use. (more on this below)
Stocky has a "perform adjustment" button that will make the adjustments automatically in Shopify.
For our business (returns to internal backstock/warehouse), that same RTV CSV file is imported into Netsuite as an RA, which auto-assigns a sequential RA number. That number goes into the notes section in Stocky on the adjustment, thereby tying out the transaction.
Net effect is removal of Inventory (cost) from Shopify POS and adding the value of that inventory back into our ERP System's virtual warehouse (bringing the cost back onto the balance sheet in the parent entity).
It's not perfect, but at least there's no hand-keying. I researched for 3 hours trying to find something better before putting this in place, found nothing better.
Starting a B2B store is a big undertaking that requires careful planning and execution. W...
By JasonH Sep 23, 2024By investing 30 minutes of your time, you can unlock the potential for increased sales,...
By Jacqui Sep 11, 2024We appreciate the diverse ways you participate in and engage with the Shopify Communi...
By JasonH Sep 9, 2024