Topics

All had been working well with our site, but beginning on 12/1/11 customers are unable to checkout (everything had been fine for over a year). Now when checking out, customers get a java.net.ConnectException Connection Timeout and their credit cards are never processed.

I am able to login to authorize.net from a web browser and go into my account no problem. Any idea why this problem would 'all of the sudden' begin occurring???

Thanks!

Using One Page Checkout:

In previous versions of KonaKart, the company name would appear in the delivery address on the order confirmation page. I also have Company=true in the Konakart Admin->Customer Details. In the latest version, the company name seems to be missing from the delivery address (and invoice template), even if a company name was entered. I can see that the template uses $order.getDeliveryFormattedAddress(). I would like to have the company name displaying in the shipping and billing addresses, but right now it only shows the customer name. I'm guessing it is a configuration with One Page Checkout...just looking for a little direction on where to look. Thanks.

I was hesitant in posting this thinking it was just a problem on our site upgraded to 5.5.0.0. But I have duplicated the same problem using the plain vanilla windows installation KonaKart-5.5.0.0-Windows-Setup.exe.

Only changes made were to configure the email options to allow for sending email (no changes to templates, etc). The emails are received just fine, including the new password, however, the password contained in the email will not work for the customer email whose password was reset.

Has this problem been seen before?

I thought I was loosing my mind when I could not get the one page checkout to work on my site when upgrading to 5.5.0.0 from 4.0.0.0. So I went back and performed a new installation on a Windows 7 (x64) machine using KonaKart-5.5.0.0-Windows-Setup.exe. I created a fresh/empty database and let Konakart populate the database with the demo data.

Launching the demo site and checking out (all using localhost:8780 demo site created by KonaKart with no changes made in KonaKartAdmin) I attempt to checkout using a new email address. I am then prompted for checkout information (name, address, country, etc). After entering a password and clicking 'continue', nothing happens. Click 'continue' again and the error pops up that says this email address already exists. It is impossible to move past this screen.

My environment:
Windows 7 (x64) sp1
Mysql 5.5.15 (x64)
JDK 1.6.0_23 (x64)

No changes or extra libs added. Just run right after install with the default store.

Hi KonaKart folks

This week I upgraded a 4.0.0 version of KonaKart to the new 5.5.0.0 version (community edition). Checkout performs normally UNLESS it is a new customer.

After entering an email and the system determines it is a new email and the customer information page shows, upon clicking the continue button at the bottom to continue to checkout...the system just hangs until you finally click continue again upon which the error message now shows that this email already exists.

Now if you go through the checkout procedure again after this error message with all goes well (because you are skipping the customer info page). What do I have wrong in my setup?? Its been driving me crazy for days now. Thanks!

Dean

We are currently using Konakart 4.0 and we will be upgrading to the latest this month. I see that 5.2 came out in January. If I remember correctly, releases seem to happen every 6 months. Is there a soon to be release version that it would be smart to wait for?  Thank you.

If KonaKart had bar code shipping label printing integrated within the shopping cart this would be a highly valued feature. I can imagine that this would be quite a task, but it could be an enterprise feature (unless you still wanted to make it a community level feature and capture even more market share). Even a smaller company like ourselves that has no need for the enterprise features would have to choose the enterprise extensions simply due to the time saving advantages of being able to click and ship orders directly from KonaKart (now shipping is done by re-entering copying/pasting the information from the KonaKart system into the shipping software).

1) Users would have there own UPS, Fedex, or USPS account numbers to use.
2) Intuit's Quickbooks accounting software does this for its users. Users can print a shipping label (UPS and Fedex) from the same screen that an invoice is created from.
3) An even cooler feature would be the ability to have multiple rates listed (ie UPS and Fedex rates) so that the order processor could print and ship using the least expensive route.

I have no idea how involved this would be, but I can see the value in it as a KonaKart user. It would be an awesome feature.

We needed a promotion based on the number of items purchased from the same manufacturer. With the default promotion modules we were able to let dollar amounts that would trigger a discount, but the total would not distinguish between non promotional manufacturers vs. promotional manufacturers. For our needs, the promotion was a 10% discount when 3+ items were purchased from the same manufacturer. I had previously posted this solution in the Configuration thread about this discounting need, but this modules would be more appropriately posted here. You will see two "QuantityDiscount.java" files: one is for the konakart package, the other for konakartadmin package.

These are fully functioning with my konakart v4.1.0.0.

Can the coupon code 'stick' so that the user does not have to enter the code again at the checkout screen? Currently the system allows the user to enter a code when viewing the cart contents and any discounts are shown, however, when checking out the user needs to remember to enter the code again (even though the code was entered on the previous screen). In a previous posting I was informed that this could be customized to work this way--but I have been giving this some thought and wonder why it should ever notwork this way. This (coupon code stickiness) should normally be remembered through the user's session (at least this is how most sites seem to work).

Just some feedback. Konakart is a fantastic platform and I have been quite pleased with it! Keep up the good work!

Using 4.0.0.0

I have noticed that when viewing cart contents and entering a coupon code -> Update, the discount will show (this is a % off discount code) and the updated total is correct. However, when checking out (registration is required) the discount is lost and the customer must enter the coupon code again on the final screen before confirming payment. This confuses some customers when they forget to enter the coupon code again at the end prior to entering payment information.

Is this a bug, or do I have something wrong in my setup?

Thanks a bunch.

Is there an issue (or configuration problem) that will not allow the search for an order ID? On the order screen in the admin application and also on the invoice, it shows an order ID. If I try to search for that order ID using the search function at the top of the order screen, it will fail to find that order ID even if I can see the order ID in the list on a previous screen.

In there a special trick I am missing?

Hi Konakart folks. I am trying to import customer contacts into the konakart database via a JDBC connection and the API example provided for Registering a customer. I keep getting the error about "Konakartadmin.properties" file not found in the class path. How should I specify the connection properties for this simple app (without putting the file in the classpath)?

I am loading customer information from an access database into the konakart database on a local machine to test out the process. Is there a more simple way to get this accomplished? Here is what I have been trying (just a simple java application to communicate with the API library):

import java.sql.*;
import com.konakartadmin.app.*;
import com.konakartadmin.appif.*;

public class Main
{ protected static KKAdminIf eng;
  private static String DEFAULT_USERNAME = "<mykonakartusername>";
  private static String DEFAULT_PASSWORD = "<mykonakartpassword>";
  protected static String sessionId;

  public static void main(String[] args)
  { starterUp();
  }
  private static void starterUp()
  { try
    { init();
    }
    catch(Exception e)
    { System.out.println("StarterUp error: "+e);
    }
    loadMergeRecords();   
  }
  private static void loadMergeRecords()
  { Connection con = null;
    PreparedStatement statement = null;
    ResultSet rs = null;
    try
    { con = getConnection();
      statement = con.prepareStatement(
      "SELECT * FROM <Access Table>");
      rs = statement.executeQuery();
      while (rs.next())
      { AdminCustomerRegistration acr = new AdminCustomerRegistration();
        //required stuff
        acr.setGender("m");
        acr.setFirstName(rs.getString("FirstName"));
        acr.setLastName(rs.getString("LastName"));
        acr.setEmailAddr(rs.getString("Email"));
        acr.setStreetAddress(rs.getString("Address1"));
        acr.setCity(rs.getString(rs.getString("City")));
        acr.setState(rs.getString("State"));
        acr.setPostcode(rs.getString("Zip"));
        acr.setTelephoneNumber(rs.getString("Phone"));
        acr.setPassword("12345");
        acr.setDontEncryptPassword(false);
        acr.setBirthDate(new java.util.Date());
        //optional
        acr.setCountryId(223);//US
        int custId  = eng.registerCustomer(sessionId, acr);
        System.out.println("Id of the new customer = " + custId);

        // Read the customer from the database
        AdminCustomer cust = eng.getCustomerForId(sessionId, custId);
        if (cust != null)
          System.out.println(cust.toString());
        else
          System.out.println("The customer could not be read from the DB");
      } 
    }
    catch (Exception e)
    { e.printStackTrace();
    }
    finally
    { closeConnections(rs, statement, con, "loadMergeRecords");
    }
  }
  static protected void init() throws ClassNotFoundException, InstantiationException, IllegalAccessException, KKAdminException
  { Class<?> engineClass = Class.forName("com.konakartadmin.bl.KKAdmin");
    eng = (KKAdminIf) engineClass.newInstance();
    sessionId = eng.login(DEFAULT_USERNAME, DEFAULT_PASSWORD);
  }
  private static Connection getConnection() throws Exception
  { String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
    String url = "jdbc:odbc:<system dsn database>";
    String username = "";//none needed
    String password = "";//none needed
    Class.forName(driver);
    return DriverManager.getConnection(url, username, password);
  }
  public static void closeConnections(ResultSet rs, PreparedStatement statement, Connection con, String method)
  { try
    { if (rs != null)
        rs.close();
      if (statement != null)
        statement.close();
      if (con != null)
        con.close();
      rs = null;
      statement = null;
      con = null;
    }
    catch (Exception e)
    { System.out.println("Error closing connection in " + method + ": " + e);
    }
  }
}

Do these modules actually allow the printing of the shipping bar coded label directly from KonaKart admin? Or do these modules simply do the shipping charge calculation? Thanks!

I have a promotion for customers to save a percentage % when purchasing a minimum number of products from the same manufacturer (the customer saves 10% when buying 3+ items from the same manufacturer). Here is what I have done:

1) Promotion Type: Product Discount
2) Active: Checked    Cumulative: checked
3) Min. order value: 100   Minimum quantity for a product: 1
4) Discount: 10   Percent/Amount: True

Using rules I have:
1) Excluded all products BUT the products of this manufacturer (Manufacturer A).
2) Made promotion active on only 1 manufacturer (Manufacturer A).

Problem:
Using the $100 order minimum to ensure 3 items are purchased for the discount doesn't preclude other manufacturer items from being used to reach the order minimum and get the discount. A customer doesn't have to buy 3 products from the same manufacture, example (promo is for Manufacturer A's products):

Customer buys 1 product from manufacturer A: $50
Customer buys 2 products from manufacturer B: $60
Order Total: $110 minus the promo discount shown

The promo discount shows because one item from manufacturer A is purchased along with others from Manufacturer B and the total reaches the order minimum.

Is there a way around this? I can't seem to figure out how to set it up to work properly??? I have a production site available if you need to see this in action. Thanks!

I was looking through the konakart docs about product returns and credit card refunds. The documentation seems a bit limited on this functionality. Creating RMAs is simple enough, its the processing of the refund that needs help.

Can you point to any examples or provide some examples for configuration of this option with one of the payment options (ie Authorize.net)?

It is great seeing FedEx and UPS integration with KonaKart. Any plans on integrating USPS (US Postal Service) shipping into KonaKart? This would be a very powerful feature for stateside users. USPS is more competitive that UPS/FedEx with some shipping options (Media Mail, International flat rate shipping, etc.)

Thanks, and keep up the good work!

My desire is to have a single database for keeping orders and customer info and processing their payments--this when orders and information are received offline. It is time consuming to add the customer data with all the clicks that are needed and then to search and add each item to a cart, etc.

An awesome solution would be a generic order page, where everything is inputted at the same time:
1) Customer bill/ship information
2) Item numbers, description/title, and cost (for simplicity sake, no need to link item numbers with catalog items), just a simply order form that will have a total.
3) With a single click, process the credit card.

Just an idea for people with online store and physical stores or trade show sales. This would allow the central storage and processing of customer orders and payments--with speed and efficiency.

What do you folks think?

1) Is there a suggested plan of action for upgrading any jsp changes between versions. We started using KonaKart with 2.2.6 and want to move to the 3.2.0.0 version. I see the scripts for the database changes, but when one makes changes to the jsp's involved is there an easier way to take advantage of any additions/fixes without running diff programs on each file?

And

2) Unrelated to upgrading--I'm excited to see FedEx shipping has been integrated with 3.2, are there any plans to integrate UPS or USPS (United States Postal Service) in future releases? For book sellers, USPS is an important shipping option.

I entering in customer orders taken at a trade show using the admin application. I'm running into a problem on longer email addresses--the system allows addresses from 2 to 32 characters. I need a limit higher than 32. I've searched all the configuration options in the admin application.

Where can I increase this limit?? Thanks!

Is it possible to enter orders through the admin application? This would help when taking orders offline and then process them online (much like a call center would). I thought I had read something about call center functionality, but the only way I can see to enter orders is by going in as if you were a customer--but then you MUST have an email address for the customer. Hopeful the admin application should allow entry of orders with minimal information. Any ideas?