CSV Import of data of Offline Sales

[kiwigal]

Hi there

I want to be able to import CSV data from my offline sales, so that I can manage inventory levels from all sales sources. 

My data from offline sales is stored as a CSV file, and has product information etc.

I was thinking that I would use CSVI Improved to match the data fields from my CSV export from the offline sales and import it into VM with the corresponding tables in VM.

Do any of you have suggestions on whether this would be the right way to do it, or can suggest an alternative?

Thanks

[jenkinhill]

I would use CSVI

[AH]

I don't think you want to see the orders on VM from exterrnal sales

If that is the case, I think what you may want to do is adjust the live VM stock based on external sales

By matching against product_sku

product_in_stock = product_in_stock - item_external_sales

I think that CSVI only allows you to set the stock value on import - not adjust the current stock value

Someone should be able to write such a function for you that would integrate into Joomla/VM or you could talk to the CSVI developer

[kiwigal]

Ok, thanks for the suggestions.  I think there are alot of smaller sellers where this could be extended, that have offline sales ie: sold instore that don't have a centralized system for inventory tracking of parts etc, and/or not the budget to integrate their POS with their online sales.  Typically in the past we've imported the sales data from the webstore into their accounting system for the purposes of managing sales, but it doesn't address the inventory management aspect that some manufacturers rely on.

[AH]

We use a simple CSV file to update our stock

It contains the SKU and a Value (and some other stuff that is ignored for importing)

Using this one format and some simple php/SQL it is easy to:-

Update the stock with orders
Deduct items from stock based on sales from non e-commerce
Set the stock value (stock count)

It should be straightforward for the CSVI team to make adjustments to facilitate this functionality