close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Deleting Products, Options & Shipping

Thread began 12/09/2010 11:46 pm by mr. graphic | Last modified 2/15/2011 6:36 pm by Jason Byrnes | 1362 views | 6 replies |

mr. graphic

Deleting Products, Options & Shipping

I have these 4 Issues (PS3), please take a look:

1 - I have deleted a product which I do not see on the front end but it keeps showing in the admin/products area which is very "Annoying", please let me know what to do..

2 - I have set up about 20 products with many options of length and color, and now some of the products show their options out of order, 32/24/16/18/10/12 where the first few show the option of size correct, 12,14,16,18,24,32, etc. (How do we correct this & why)..

3 - In this store, I will offer 2 shipping methods, Is there a way to choose the shipping before going to PayPal, just like any other store out there you pick your choices, and then shipping and then you pay after you have explored your shipping options.

4 - I placed a 10.00 item to test, I go through the checkout and after continuing with Paypal last step, I come back to a page where it wants me to login again, where the

Order Summary has the price, but the
PayPal Express Check out is empty
Shipping Info = empty
and email address field is not available
Password = Field Open
Confirm Password again = Field Open

Sign in to reply to this post

Jason ByrnesWebAssist

1) was this a product that had options You will need to delete the options before you can delete the product itself.

2) on the product_details.php page, add an order by clause to the options recordset:
change:

php:
$query_OptionValues = sprintf("SELECT ps3_options.OptionID, OptionName FROM ps3_options INNER JOIN ps3_optiongroups ON ps3_optiongroups.OptionGroupID = ps3_options.OptionGroupID  WHERE ps3_options.OptionGroupID = %s  ", GetSQLValueString($OGIDParam_OptionValues, "int"));



to:

php:
$query_OptionValues = sprintf("SELECT ps3_options.OptionID, OptionName FROM ps3_options INNER JOIN ps3_optiongroups ON ps3_optiongroups.OptionGroupID = ps3_options.OptionGroupID  WHERE ps3_options.OptionGroupID = %s  ORDER BY OptionNameOptionName ASC", GetSQLValueString($OGIDParam_OptionValues, "int"));




3) Power store does not support selecting the shipping provider, it would require hand coding to accomplish . This has been added a s a feature request to be considered for a future version.

4) this is an issue that was corrected in the Power Store 3.01 upgrade, make sure you are using the power store 3.01 files that are available from the download center.

Sign in to reply to this post

mr. graphic

Deleting Products, Options & Shipping

Thanks for Reply:

As far as issue

#1 (I have deleted a product which.....) when I go to manage, I do not see anything so no options are there for me to remove, the product shows up in the admin but when I click on
A) "Product Details" (I see a shopping cart that is empty)
B) "Update" (It's empty)
C) "Manage Options" (It's empty)
D) "Delete" (It let's me delete but again it's there listed)
E) "Charts" (Nothing)
so as you can see I have tried everything within that product, there is nothing else to delete, options or otherwise.

#2 (Will do)

#3 OK

#4 I think I did upload 3.01 but that have been an old store so I will check..

Sign in to reply to this post

mr. graphic

Order of The Options

Item #2
"on the product_details.php page, when I did what you asked, I received this error on the front page "Unknown column 'OptionNameOptionName' in 'order clause'" so I put back the old for now..

Please let me know

Sign in to reply to this post

Jason ByrnesWebAssist

sorry the order by clause should be:
ORDER BY OptionName


php:
$query_OptionValues = sprintf("SELECT ps3_options.OptionID, OptionName FROM ps3_options INNER JOIN ps3_optiongroups ON ps3_optiongroups.OptionGroupID = ps3_options.OptionGroupID  WHERE ps3_options.OptionGroupID = %s  ORDER BY OptionName ASC", GetSQLValueString($OGIDParam_OptionValues, "int"));
Sign in to reply to this post

mr. graphic

Drop Down of Options

They seem to be mostly fine, but take a look.. I still have a problem with this....

Products_Detail.php?ProductID=149

Sign in to reply to this post

Jason ByrnesWebAssist

for the single digit sizes to show at the top of the list, you will need to add a leading 0:
08" - 09"

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...