POS, Stock value, whosale and traditional shop solution

[Juhana]

Hello all,

I'm running family owned whosale business, where we are using VM 2.02o for selling B2B. Price configurations, tax settings etc. are working correctly and website is running quite smoothly.

The problem is, we also have a traditional shop where we use different software for selling to private customers. This same software is used also to create invoices for all B2B customers from Their web orders and keeping up the stock value (quantities and stock value in €). As you can guess, this is way too complicated and slow way to work- not to mention stock qty's tend to have errors all the time.

If we move our stock completely to VM, is it possible to add somewhere in price settings  our own purchace prices to keep up the stock value also in € ?

From this forum i found a suitable POS to take care of selling in our "traditional shop" ("POS for Webshops"). If anybody have experienced with this software, all feedback is more than welcome

Thanks in advance,
Juhana

[AH]

I also wish to add a "cost price" to the Products - that is not the same as the "base price"

But the problem with adding this to the product table is that it gets overwritten by VM updates.

You could add a custom field to each product that is hidden from the frontend.

Alternatively you could add your own table based key = product_id and all the fields you want to add to a product could be stored in this table

Then write the code to manage this within the product add/edit pages.

I think I will be going the "additional table route"  but it will take me a while to write :-(

[Juhana]

Hello Hutson,

Thank you for your suggestions. It seems i'm not the only one facing this problem?

Table based key you mentioned feels better solution for us: should VM update happens, we are not capable to handle such a situation and damages might be huge. I will give a call to my "Webmaster" and find out is He willing/ capable to write this kind of a code or do we somebody else to do it? Unfortunately my guess is latest...

Hopefully somebody else would also reply to this post and let us know there is already extension available...somewere....

-Juhana

[AH]

Hi

Another thing that I would suggest before using money on coders

Use the data capabilities of excel to run queries on the vm database to pull the product description and the fields you want from the product table

you could connect to the database using the mysql odbc connector then create a report using excel and mysql

http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-dsn-windows.html

excel data connections

http://office.microsoft.com/en-us/excel-help/overview-of-connecting-to-importing-data-HP010342748.aspx#BMunderstanding_data_connections

and

http://office.microsoft.com/en-us/excel-help/overview-of-connecting-to-importing-data-HP010342748.aspx



You can then match the sku's to a pricing sheet using excel vlookup function

[margen]

i also agreed and want to say that...Thank you for your suggestions. It seems i'm not the only one facing this problem?

odesk test answers

[Maxim Pishnyak]

"Our own purchace prices" - normal VM prices.
"Price overrides" - sales VM prices.

[AH]

Maxim

Are you sure that someone should be using price overrides for their standard "normal" sales price??

[Maxim Pishnyak]

I see this as the only possibility to use standard VM features for mentioned task. Debatable, Hutson?

[AH]

I would prefer not to use overrides unless I really neede to override a price, certainly not as my main Sales price

[Maxim Pishnyak]

Not enough smoothy control with the help of CSVI?