Updating Product Prices / Costs directly into the Table s01_Products

[captainboom]

David, I find myself scratching my head on this too. At one point there were issues getting the file emailed to him (but I think that's been resolved). He does know how to use FTP to retrieve the file. This site also uses Filemaker with a custom orders export file (but that doesn't connect back to Miva). I suspect he's an old-school DBA. I've made the store owner (and the DBA) aware of what's coming down the pike. If you'd like to reach out to them I can put you in contact.

I've got a Filemaker middleware solution running between Miva and Finale Inventory that currently has two functions. One is to pull orders out of Miva, let us manually review them (long story, but we need it) and push to Finale at the click of a button. The other function is to automagically keep our Miva inventory up to date when there are inventory changes in Finale that are external to Miva. Filemaker is currently doing these things by running timed scripts and utilizing the JSON API for both ends of the process. Eventually, we'll likely move to triggering the Miva events into Filemaker with webhooks and order workflows instead of running the timed scripts.

By using the Filemaker solution, we've reduced our manual processing time from 20 minutes per order to about 2 minutes, and the inventory updates are now completely automatic. A current project we're working on is to integrate Filemaker with our Square POS and Miva using webhooks, so we can offer buy online for local pickup and keep our local inventory up to date between Square and Miva. Our local inventory is physically remote from the warehouse inventory that's using Finale, and the point of truth for the local inventory will be in Filemaker.

I'm running Filemaker Server on a dedicated Mac Mini locally, but this can also be done in the cloud with a hosted solution.

All of the above to say that I'm pretty happy with the solution using the API so far, and it never touches the database directly. Hope this gives you some ideas.

[lesliekirk]

A current project we're working on is to integrate Filemaker with our Square POS and Miva using webhooks, so we can offer buy online for local pickup and keep our local inventory up to date between Square and Miva. Our local inventory is physically remote from the warehouse inventory that's using Finale, and the point of truth for the local inventory will be in Filemaker.



All of the above to say that I'm pretty happy with the solution using the API so far, and it never touches the database directly. Hope this gives you some ideas.

You had me at Square POS integration. I am seeing a number of store owners move to other eCommerce solutions just to have the (built-in) POS ability. These are stores that either have brick & mortar stores, do a number of popup-type events or both. All of them also needed the ability to have real-time inventory.

In the case of the store I've been mentioning, neither of these has been needed and I have begun intensive training on how to use the built-in Import to do price changes. Next up - how to do bulk product additions.

LOL, did I mention I love teaching this stuff?

[lesliekirk]

Thanks Nick

As for the "Calculate Predicted Discounts and Sale Price" not being checked in the template - I did go back, check it, and update the template. The issue disappeared.

Nick I'm having the same issue with the Related Products display. It's still showing the old price and checking the "Calculate Predicted Discounts" for the Related Product List Layout is not fixing this. Should I reach out to support for this? I did manually rerun the "Pre-Calculate Discount Prices" Scheduled Task. That didn't help either.

[Nick]

lesliekirk You could have them take a look but if we go back to your original post you mentioned, there are direct database updates to the price which is more than likely the issue. When you update that functionality the Miva features will work as expected but if the store is updating the price via direct calls to the database then you are always going to have issues related to pricing in the store because that is not the correct way to update pricing.