Changed Product Type - now product gone

Good evening gang,

Interesting new development. I moved all my products to Document-General, as per Linda's FABU SQL statements; now the invites are not added to cart, but other products are

However,

as indicated in the pictures below - once I modify the products' description the following happens:

• the quantity discount from 0-74 appears as $0.00
• Pricing control is totally disabled, so I cannot change any pricing(!?)
• The model and quantity disappear from admin (pic in next post)

Is this a feature?:huh:

As always, your most helpful comments are appreciated.

~Laura

Here is the pic of the admin panel - after product description modification

The Problem with Document General is ... you cannot see the Prices to know if they are set ...

Some of your products do that, while others do not ...

And it is difficult to adjust anything to do with pricing as Document General products are filtered out of the Admin for things such as Product Price Manager ...

You may need to add a quick switch to flip between Product General and Document General so that you can update these products if you want to manage prices etc.

Oh crud! I really wish I knew that before I made all those changes.

So - what is this quick switch you're referring to? Do I need to get a programmer to write this?

Thanks~
Laura

you could use a simple command in the Tools ... Insert SQL Patches ...

Switch to Products General

UPDATE products SET products_type = 1 where products_id = 27

Switch to Document General

UPDATE products SET products_type = 3 where products_id = 27

Where products_id is the product to change ...

NOTE: you might want to disable or status OFF the product when working with it between states ...

Switch to Products General and turn OFF status:

UPDATE products SET products_type = 1, products_status = 0 where products_id = 27

Switch to Document General and turn ON status:

UPDATE products SET products_type = 3, products_status = 1 where products_id = 27

You could also build this in as a toggle button or something in the admin if it is hard to flip between things ...

You always make it look so easy!:yes:

I'm assuming I can just put the site in maintenance mode when doing this, rather than changing the status of each product.

Thank you - again.

Laura

That too would work ...

The idea is don't let the customer play while you are playing ... :smile:

Ajeh:

you could use a simple command in the Tools ... Insert SQL Patches ...

Switch to Products General

UPDATE products SET products_type = 1 where products_id = 27

> 
> Switch to Document General
> ```php
UPDATE products SET products_type = 3 where products_id = 27

Where products_id is the product to change ...

Hi Linda/Ajeh (or anyone who may be 'in the know')

Strange problem. The above statements worked great when I was changing the items from Product General to Document General.

However,

I created a new design as a native Document General. Then I wanted to make it a featured product, which I could not, as my Document General items do not populate in the choice list. So I used the statement to change back from Document to Product - but the statement fails.

Is it because the item originated as Document General? G-d I hope not, as this has become very unwieldy to administrate. (I'll put my wish list in after this:smile: )

I would put them all back in Products-General and turn it into showcase mode, but I have to have an add to cart for samples, and a few other items.

I'm technologically exhausted:blink:

Thanks...again
Laura

Update -

I can't change anything back to Products. The statement fails for all items that I changed over to Document General.

Okay - I think I see what may have happened -

The SQL statements as listed above do not have the semi colon. I don't know if sending those statements without the colon screwed up my DB, but what I'm going to do is restore my backup and try again.

I wish I could get this intimate with my car's engine :P

Well that was a waste to time - I restored an earlier version from the 15th, ran the statement, with semi colon in tact and I get this:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'in:
[If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Thanks,
Laura

I am not sure off the top of my head why you would be getting the error with the statements with the semi-colon on the end ...

Try closing the browser windows ... clear cache ... and try again ...

Thanks Linda,

I have to remember the implications of having a web interface, as opposed to std. client/server. I'll remember that for future glitches.

~Laura