Announcement

**Rick Wilson** · 12-10-09, 11:27 AM

Re: Wombat Beta 4 is out - PLEASE READ Part 2

Changes:
--------
Bug #5046
Bug #5027
Bug #5047
Bug #5023
Bug #5019
Bug #5041
Bug #5004
Bug #5055
Bug #4953
Bug #5016
Bug #4927
Bug #5059
Bug #4937
Bug #5005
Bug #5064
Bug #4971

Database functions now return EOF error on EOF, so you can tell if a return value of 0 was just because nothing was found, or because there was a database error.
Inventory at the attribute level
CSSUI now allows you to lookup order history by email address and zip code
New order processing operations for IGS

Database Changes:
-----------------
sNN_Attributes:
Add "inventory" bool, default value 0

sNN_AttributeTemplateAttrs:
Add "inventory" bool, default value 0

sNN_BasketItems
Add "variant_id" integer, default value 0

NEW STOREKEY ProductVariants

NEW TABLE sNN_ProductVariants
product_id NUMBER( 0, 0 )
variant_id NUMBER( 0, 0 )
dimensions NUMBER( 0, 0 )
part_count NUMBER( 0, 0 )
attr_id NUMBER( 0, 0 )
attmpat_id NUMBER( 0, 0 )
option_id NUMBER( 0, 0 )

INDEX sNN_ProductVariants_1 ( product_id, variant_id )
INDEX sNN_ProductVariants_2 ( product_id, attr_id, attmpat_id, option_id )
UNIQUE INDEX sNN_ProductVariants_3 ( product_id, variant_id, attr_id, attmpat_id, option_id )

NEW TABLE sNN_ProductVariantParts
product_id NUMBER( 0, 0 )
variant_id NUMBER( 0, 0 )
quantity NUMBER( 0, 0 )
part_id NUMBER( 0, 0 )

INDEX sNN_ProductVariantParts_1 ( product_id, variant_id )
INDEX sNN_ProductVariantParts_2 ( part_id )

NEW TABLE sNN_ProductKits
product_id NUMBER( 0, 0 )
attr_id NUMBER( 0, 0 )
attmpat_id NUMBER( 0, 0 )
option_id NUMBER( 0, 0 )
part_id NUMBER( 0, 0 )
quantity NUMBER( 0, 0 )
pos NUMBER( 0, 0 )

INDEX sNN_ProductKits_1 ( product_id, attr_id, attmpat_id, option_id )
INDEX sNN_ProductKits_2 ( part_id )

NEW TABLE sNN_ProductVariantPricing
product_id NUMBER( 0, 0 )
variant_id NUMBER( 0, 0 )
method NUMBER( 0, 0 )
price NUMBER( 10, 2 )
cost NUMBER( 10, 2 )
weight NUMBER( 10, 2 )

UNIQUE INDEX sNN_ProductVariantPricing_1 ( product_id, variant_id )

sNN_Products
Add "sku" CHAR( 50 )

**Rick Wilson** · 12-10-09, 11:38 AM

Re: Wombat Beta 4 is out - Release Notes

Miva Merchant 5.5 WB4 (wombat-beta-4)
This stream will update Miva Merchant to Wombat-Beta-4:

When you're ready, you may scroll to the bottom of this page and hit the "Install" button to begin.

Release Notes
Detailed information about the Wombat beta may be found in the Miva Merchant Community Forums.

New Features Introduced in this Beta:
Innovative Gateway payment processing module has been updated to support the advanced payment functionality in the new order management system.
Import and Export module user interfaces have been redesigned.
When using CSSUI, Order History may now be retrieved using the billing email address and zip code. This functionality will also be provided for MMUI in a future release.
Inventory availability and dynamic pricing may now be controlled at the attribute level. A new setting (the I column) on the Attributes tab allows attributes to be flagged as Inventory Attributes, and two new tabs on the Edit Product screen are now available for configuring combinations of attributes.
A new Store Morph item, "attributemachine", provides functionality to automatically enable/disable attribute values and display live inventory and dynamic pricing. The options for this item are configured on the "Attribute Inventory" tab of a page with the item assigned.
When a database query fails to find a record, g.Error_Code is now set to 'EOF'. This allows a return code of 0 due to an error to be differentiated from a return code of 0 because no records were found. This flag may be checked with the DB function Error_Is_EOF().
New common non-store pages have been added to CSSUI. (About Us, Contact Us, etc...)
Bug Fixes:
#4927 - prodimpt: "Delete Existing Data When Imported Data Is Empty" deletes all custom field values
#4937 - No page heading for 'Add an Affiliate' in admin
#4953 - Frameworks not implementing their contained category_tree component correctly
#4971 - External CSS files are not parsed for images when exporting a framework
#5004 - It is possible to create an Affiliate account with no password at runtime.
#5005 - When custeml module is set to inactive, you cannot create a new store.
#5016 - CSSUI does not create POLICY page
#5019 - CSSUI: Creating an account during checkout should bypass OCST
#5023 - CSSUI form components should use variables for invalid style instead of tons of
#5027 - cmp-cssui-mv-xxx components should drop "mv"
#5041 - CSSUI: Missing CSS file fails during store creation without an error message
#5046 - CSSUI: "Home" button on checkout screen does not use short links
#5055 - Affiliates are shown their logins inside an editable field on AFED
#5059 - EuroVAT Product Price Includes VAT option shouldnt calculate tax for other Basket Charges
#5064 - In CSSUI Framework the navigation bar Account links are incorrect
Changes from the module-google-5 and module-usps-4 patches have been integrated

**wmgilligan** · 12-10-09, 06:02 PM

Re: Wombat Beta 4 is out - PLEASE READ Part 1

Hey Rick,
Some of this is really exciting. I have one question so far - what are the plans if any of the new pages already exist in a site? ie - FAQS.

Bill

**Rick Wilson** · 12-10-09, 07:03 PM

Re: Wombat Beta 4 is out - PLEASE READ Part 1

The new pages will be part of the default skin as well as our skins for sale. At this time no plans for them other than that.

**wmgilligan** · 12-11-09, 06:19 AM

Re: Wombat Beta 4 is out - PLEASE READ Part 1

Does this mean, that if a page has been created with the code FAQS and the customer does an update (and the default skin includes FAQS), the system would not overwrite the existing page, and/or not fail the install?

**Rick Wilson** · 12-11-09, 08:27 AM

Re: Wombat Beta 4 is out - PLEASE READ Part 1

It fails the initial test, so it doesn't break the store. Right now the only option if you want to finish the install would be to rename the Page that is conflicting.

Since we have no specific use other than in our skins, probably the easiest would be to go into Maintenance Mode, rename the "offending" pages, run the updates and then swap the names.

**wcw** · 12-15-09, 05:44 AM

Re: Wombat Beta 4 is out - PLEASE READ Part 1

What does this new field do?

sNN_Products
Add "sku" CHAR( 50 )

**Rick Wilson** · 12-15-09, 07:57 AM

Re: Wombat Beta 4 is out - PLEASE READ Part 1

We got a lot of requests from customers that they wanted a separate SKU from Product Code, for various reasons, so we've added the field.

I'll ask Jon for some specifics on how it will be made available for use.

**wcw** · 12-15-09, 08:16 AM

Re: Wombat Beta 4 is out - PLEASE READ Part 1

On my MMUI product list page I have a column for availability. In the product that is attribute inventory, that cell is blank and the variables are missing except for inv_active which is 0. The others that are standard inventory have
:PRODUCTS[6]:INV_ACTIVE=1
:PRODUCTS[6]:INV_AVAILABLE=33
:PRODUCTS[6]:INV_INSTOCK=33
:PRODUCTS[6]:INV_LEVEL=in
:PRODUCTS[6]:INV_LONG=33+available+for+immediate+delivery
:PRODUCTS[6]:INV_LOW_LEVEL=0
:PRODUCTS[6]:INV_LOW_TRACK=0
:PRODUCTS[6]:INV_OUT_LEVEL=0
:PRODUCTS[6]:INV_OUT_TRACK=1
:PRODUCTS[6]:INV_SHORT=In+Stock

So I put the API function Runtime_Product_InventoryFields_Read in a module and tested. It is returning the same results, ie inv_active=0. Shouldn't that API function check for variants and sum the quantity on hand and report it as in stock if one or more of any variant exists? Or should it stay like it is, ie blank. If blank, it is going to confuse customers if they see XX available for most products and then blank for attribute inventory products.

**Rick Wilson** · 12-15-09, 10:06 AM

Re: Wombat Beta 4 is out - PLEASE READ Part 1

It would be far more confusing to report back some arbitrary number like the aggregate total of all of them combined and until they select an Attribute it's not possible to know how many are available.

The new "attributemachine" Item allows for that information to be reloaded dynamically as customers select and change their attributes, it also asks them to choose a required set of attributes to see the inventory level as opposed to leaving it blank.

The AttributeMachine works on the PROD, PLST and CTGY pages and anywhere you have a product list, such as related products, search results, etc...

**wcw** · 12-15-09, 10:20 AM

Re: Wombat Beta 4 is out - PLEASE READ Part 1

I tried assigning the attributemachine to the PLST page template but the inv_active still reported 0. Shouldn't it at least report that inventory tracking is active. I can understand not telling me there are 50 in stock, but it should say something, eg "in stock".

**Rick Wilson** · 12-15-09, 10:27 AM

Re: Wombat Beta 4 is out - PLEASE READ Part 1

Did you add the head code stuff that goes with it?

**wcw** · 12-15-09, 10:33 AM

Re: Wombat Beta 4 is out - PLEASE READ Part 1

This is a MMUI store. You didn't have any instructions about that for MMUI. Again, this is not to display anything. The variable is not getting set to inventory active (inv_active). I don't care if it displays anything. I just want the variables to get set. They aren't. It shows the inventory is inactive when in fact the product has attributes with quantities assigned to them.

**Rick Wilson** · 12-15-09, 10:35 AM

Re: Wombat Beta 4 is out - PLEASE READ Part 1

Template Code Changes (MMUI) - DOCUMENT ONLY
--------------------------------------------
PROD Page:
Add <mvt:item name="attributemachine" param="head" /> to contents of <head> tag
Add <mvt:item name="attributemachine" param="body" /> after product_display item reference

PATR Page:
Add <mvt:item name="attributemachine" param="head" /> to contents of <head> tag
Add <mvt:item name="attributemachine" param="body" /> after </blockquote> tag
Replace "Attributes in <b>bold</b> are required." with <mvt:item name="messages" />

Even though the attributemachine is an Item, it still uses JS to pull that info, regardless of what you choose to display. Try adding the info in the head tag as mentioned above and see what that does.

Announcement

Wombat Beta 4 is out - PLEASE READ Part 1

Wombat Beta 4 is out - PLEASE READ Part 1

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment