Uploading Attribute & Product Import Databases

[Pathways]

I am new to this whole thing, so please forgive me if I am posting in the wrong place. My question is similar if not exact, to those posted within this thread, however I remain confused and I am very hopeful someone here can help or direct me to a post that has the answers.

We have products that are priced by size, therefore have set the attributes accordingly. In our products import database, of course we have our prices listed, which I presume would be considered the "base" price. Therefore, we created the attributes import database to reflect prices according to size. When the attributes were created, and everything was uploaded, we had a wonderful text field next to the product listing that says "Starting At $X.OX"

Then we discovered the prices from the main product import database were being added to the orders. For instance, if a customer ordered 4oz at $4.57, the base price of that product at 1oz at $2.25 was added to the order.

So...We set the prices from the product import database to $0.00, updated and uploaded both product import and attributes, which fixed the problem of the price addition, however the "Starting At" price is also removed.

We had been told we need to update each individual product through the Admin page to allow the Starting At field to show the base price without adding it to the oder. This is not practical. We have hundreds of products and to do this piece by piece is near impossible and negates database functions.

My question is this...What do we need to change in the Attributes Controller to get the base "Starting At" price to show up again in the product listing without having to do each item individually without it being added to the actual order AND still be able to use the database uploads.

If you need a visual of what I am referring to, to help with the answer, please view the "Herbs & Spices" section of "Pathways Store" category at our website at www.mypathwaysonline.com.

Your guidance and patience is greatly appreciated.

Many Blessings!
Tracy @ Pathways

[Pathways]

Woo Hoo!!

Even though no one has answered this post, I have answered my own question and feel it would help others who find themselves having fits over attributes.

If you are experiences "phantom" price increases when customers are trying to purchase items, as we were when trying to use attributes, here is the fix.

First: Set your price in the PRODUCT IMPORT database to PBA (Priced By Attributes) and do an update upload in Admin.

Next, in the ATTRIBUTES database, there is a column titled DEFAULT. Set your lowest price items in this column only as YES.

IE: If you are selling quantities of 8oz, 12oz, 16oz, etc...your attributes should be set accordingly. Your 8oz price is your "BASE PRICE" which is reflected in the PBA settings of your imports. By setting your lowest priced item as the default, this will enable the "add to cart" or "buy it now" properly without your customers having to specifically select a quantity. If you do not set a default, and a customer does not select a quantity, the price in the cart will be ZERO. Setting the default sets the minimum quantity.

I hope this helps! It sure helped us!!!

Blessings to all!
-Tracy @ Pathways