Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

[wcw]

Re: Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

Can you elaborate so I can fix my database?

[wcw]

Re: Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

Nevermind. I just looked at the xml file for orders. This is what I see
<Code><![CDATA[1AA00006]]></Code>
<Name><![CDATA[1AA00006]]></Name>
<Price>20.00</Price>
<Weight>0.00</Weight>
<Taxable>No</Taxable>
<Upsold>No</Upsold>
<Quantity>1</Quantity>
So the code and name are getting the same value. I'll use the export wizard module to make a flat file of the line id and product name. Then write a little import routine that updates the order items database in the 5x store. Not a big deal; looks like a weekend project. Course I could alternatively use the tool kit to do a product database lookup and display the correct value but that would only work if the product still existed in the store. Order histories with discontinued products would display incorrectly. Hmm, maybe that isn't a bad idea anyway. By doing a product lookup I could hide the reorder link if the product was gone.

[wcw]

Re: Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

Follow up to the #362 post above. I could not use line_id to fix the data as a new line_id number is generated from the 4x to 5x xml import. In my store conversion scenario I was able to use order id since there were no orders in the new store and the xml import used the original order number from the old store and inserted in the new store. I suspect this would not work if there were already orders in the new store at the time when you imported orders from the 4x store, as order numbers could get duplicated. I exported the order id, product code, and product name from the 4x orditems.dbf to a | delimited flat file. I pasted the below code in an existing module's configuration screen, recompiled, updated the module, and then displayed that screen to run the code. A few seconds later and it updated all the records. Then I put the original module back in the store.

<MvIMPORT FILE = "Merchant2/00000001/prdnames.dat"
	FIELDS = "oid,prdcode,prdname"
	DELIMITER = "|">
	<MvQUERY NAME	= "Merchant"
		 QUERY	= "{ 'UPDATE ' $ g.Store_Table_Prefix $ 'OrderItems 
		 SET	name	= ?
		WHERE order_id = ? AND code = ?' }"
		FIELDS	= "prdname,oid,prdcode">
</MvIMPORT>

[ILoveHostasaurus]

Re: Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

Logging out is impossible in a shared SSL store; it removes the cookie from the browser under the secure URL but sends you back to the insecure url where you still have a cookie that apparently logs you back in. Seems like that should only be possible if Merchant's logging out function does not include deleting the session from the baskets table, since there shouldn't be anything to log back into otherwise?

[jankal7003]

Re: Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

Maybe the problem is the universal tabs at the top of the Page Templates should not be there.

HTML Profile*, HEAD Tag Content/CSS*, BODY Tag*, Global Header & Footer*, Fonts*, Misc. Colors*, Buttons*, Affiliate Links*, Customer Links*, Navigation Bar*

I don't really see this as convenient, and, if they were gone, the issue would be gone.

While it's true MM is considered a single user application, it's just not reality, especially with Miva's push for bigger and bigger business clients.

Regarding multiple users making changes in the MIVA admin -- does this issue have any kind of over-ride or fix? Or must we wait patiently for the next update?

It seems we've only noticed it since we updated to the mysql database. Is that possible?

[Rick Wilson]

Re: Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

Regarding multiple users making changes in the MIVA admin -- does this issue have any kind of over-ride or fix? Or must we wait patiently for the next update?

I don't understand what you're asking here?

[jankal7003]

Re: Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

We are losing our updates when more than one user is making changes in the admin. Is there a setting or preference we can change to allow more than 1 user at a time to make changes?

[RayYates]

Re: Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

Rick

This happens when there is more than one instance (browser window) of a page template open at a time. Each template has a copy of the "global" settings like the global header.

If you make a change to the global header in one window and then update the head tag in another window the global header changes gets over-written. This usually happens when multiple users are working on page templates, or if like me, you often have multiple tabs open different page templates at the same time.

Each tab on the page contains a copy of the data in hidden fields, so updating one tab updates all of them. At one time I understood why it was done this way in Merchant originally, but it's kind of a waste of resources to re-save data that hasn't changed.

In my modules, I always check the g.tab variable and only perform an update if my module is currently active. (Are you talking to me?)

<MvFUNCTION NAME = "Module_Utility_Update" PARAMETERS = "module var" STANDARDOUTPUTLEVEL = "">
    <MvIF EXPR="{ toupper(g.Tab) NE toupper(l.module:code) }">
        <MvFUNCRETURN VALUE = 1>
    </MvIF>

I don't think there would be any side effects if you were to perform that test in each of the functions Module_Utility_Update() on page template items that contain a "*" in the tab, and it would fix the problem.

[jankal7003]

Re: Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

Does this also apply when different users are making changes to the product database at the same time?

Rick

This happens when there is more than one instance (browser window) of a page template open at a time. Each template has a copy of the "global" settings like the global header.

If you make a change to the global header in one window and then update the head tag in another window the global header changes gets over-written. This usually happens when multiple users are working on page templates, or if like me, you often have multiple tabs open different page templates at the same time.

Each tab on the page contains a copy of the data in hidden fields, so updating one tab updates all of them. At one time I understood why it was done this way in Merchant originally, but it's kind of a waste of resources to re-save data that hasn't changed.

In my modules, I always check the g.tab variable and only perform an update if my module is currently active. (Are you talking to me?)

<MvFUNCTION NAME = "Module_Utility_Update" PARAMETERS = "module var" STANDARDOUTPUTLEVEL = "">
    <MvIF EXPR="{ toupper(g.Tab) NE toupper(l.module:code) }">
        <MvFUNCRETURN VALUE = 1>
    </MvIF>

I don't think there would be any side effects if you were to perform that test in each of the functions Module_Utility_Update() on page template items that contain a "*" in the tab, and it would fix the problem.

[RayYates]

Re: Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

Only if they are working on the same product or category. Those are keyed to specific records, where the problem above is tied to "global" records.

[kayakbabe]

Re: Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

inventory tracking doesn't work for upsale item

if an item assigned to upsale is out of inventory (inventory tracking is turned on in the store, tracking is turned on for this item, inventory quantity is 0, store is set so 0 qty is out of stock), it still shows up during check out.

If an upsale item is out of stock and there is no other upsale item available, then the upsale screen should be bypassed and not displayed.

The same product doesn't show during search and in the category it is assigned to. inventory controls seem to work everywhere but at the upsale screen.

[Hostasaurus]

Re: Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

inventory tracking doesn't work for upsale item

This was reported and confirmed as a bug in July earlier in this thread, and still hasn't been fixed.

MM support, has there been any movement on this issue?

Jen

[Rick Wilson]

Re: Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

I spoke to Jon about it recently and found out it's been a bug since the dawn of the Upsell system. So I'm not sure if it's good to admit that or not :)

However from what I understand from talking to Jon, it's going to require a fairly significant rewrite of the whole Upsell system to fix and so it's on our list for this year but not in initial PR8.

[kayakbabe]

Re: Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

drat... not good...
maybe we can handle it with storemorph?
do an if statement... on quantity of the product..
and if not enough... reload the screen to a different upsell product?
or by pass the upsell screen?

would that work? is there a flag we can give the store to change the "yes we've got an upsell turned on... to "no upsells skip this screen"
or could we program it logically to just submit the upsell screen as a 'no, thanks'
and get the customer past it without them knowing?

I would think a simple if (the inventory is sell-able flag) EQ false... we could somehow get past it.

[Rick Wilson]

Re: Miva Merchant 5.5 PR7 (Wombat) Bugs/Issues

I suspect there's a way using SMT to "fake it" however that's beyond my personal skill set. If you want to email me a rough idea, I can run it by Brennan, etc...