My SellerDeck Account | Newsletter | Free Trial

Community and Knowledge Base

Go Back   Sellerdeck Community > Knowledge Base > Online Store Issues

Search powered by Google
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Rating: Thread Rating: 4 votes, 5.00 average. Display Modes
  #1  
Old 14-Aug-2013, 04:05 PM
G.W.Green G.W.Green is offline
Administrator
Join Date: Sep 2005
Full Name: G.W.Green
Posts: 480
Thanks: 0
Thanked 66 Times in 42 Posts
Error message: 'Your shopping cart is empty. Return to the Catalog ...'

When I try checkout, I get an error, “Your shopping cart is empty. Return to the Catalog and add an item to your shopping cart before continuing.”




If you are experiencing this error message when trying to checkout on your website, please see the solution below:

This can occur when the ‘product visible’ tick box is un-ticked in the’ Prices’ tab of any product via ‘Product Details’. This is a bug in the software with reference of: SD-2451




Solution:

*You will need Microsoft Access to perform the below
  1. First make a backup of your site (File | Snapshot | Export Site)
  2. Close SellerDeck.
  3. Go to your sites folder, default (Documents -> SellerDeck 2013) and browse for a file called ‘ActinicCatalog.mdb’. This is your database. Open this in Microsoft Access by either right clicking and select ‘Open With’ or single click if file is defaulted to use Microsoft Access.
  4. Once your database has been opened in Microsoft Access, click the Queries button under Objects.
  5. Double-click Create query in Design view. Or click New in the Database window toolbar, click Design View (if it’s not already selected) and click OK.
  6. Close the Show Table box without adding any tables.
  7. Click the SQL view button on the toolbar.
  8. Replace the code with the below:

    Code:
    DELETE ProductProperties.nType, ProductProperties.sString1, ProductProperties.sStatus 
    FROM ProductProperties 
    WHERE (((ProductProperties.nType)=4) AND ((ProductProperties.sString1) Is Null));
  9. Press the 'Run' button which is shown as an explanation mark in red. It is located on the toolbar where the save button is located. Or press Query -> Run. Then press yes to run the query
  10. Close the SQL query window and close the Access Database
  11. Open SellerDeck and perform a full refresh of your site via Web -> Refresh Website.
Attached Images
File Type: png ScartE.PNG (8.8 KB, 882 views)
File Type: png ScartE1.PNG (7.7 KB, 598 views)
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off



All times are GMT. The time now is 03:23 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.