Jump to content

citabriabob

Member
  • Content Count

    20
  • Joined

  • Last visited

Community Reputation

8 Neutral

1 Follower

Profile Information

  • Location
    The Beautiful Hudson Valley of NY

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. citabriabob

    Two prices per Product

    I was hoping for a way to upload products, including the pricing group (second) price for each item; because of the relationships you mentioned, I think it's unwise to upload it to the database directly. Any other thoughts as to how this can be done?
  2. citabriabob

    Two prices per Product

    After some more research, I find that the "group pricing" is a different table CubeCart_pricing _group. I took 3 products and assigned them "Club Members' prices that are different than the "Retail Pricing". This is what the CubeCart_pricing _group looks like: price_id group_id product_id price sale_price tax_type tax_inclusive 5 1 1 14.95 0.00 1 0 10 1 10 14.95 0.00 1 0 11 1 4 14.95 0.00 1 0 Product-id correctly refers to the numeric id of the product price is shown correctly as the "Club Members"" price but price_id keeps changing even though they are all the same price group. I am trying to see if I could upload these "Club Members" prices for each product, which I thought were price_id 5, but apparently not. Crickets
  3. citabriabob

    Two prices per Product

    "Export Catalogue" only exports the first product (???) into a csv file; the pricing group is not exported at all. I am hoping to export all products, then add the group price to all products in anticipation of a mod as described above. Is there a trick to get the export working?
  4. citabriabob

    Two prices per Product

    I was able to set group price that I call "Member Price", but it does not show up in the export csv; where is this tored? Also was not able to export more than one product.
  5. citabriabob

    Two prices per Product

    This is the current setup; html pages and perl script to process. You can test it using cc #4111 1111 1111 1111. Works great, but too many items now and would be great to have the CubeCart functionality. Oops! Here is the link. http://www.aeronca.org/Store.html
  6. citabriabob

    Two prices per Product

    This is a membership organization; each new member is assigned a numerical ID. The store is open to all, but only members get the special price. I also looked at sale price, but that's a whole different animal.
  7. citabriabob

    Two prices per Product

    Thanks, bsmither! I was hoping to continue our old system, where a member enters his Member ID at order time; we manually check all orders before charging, so phony numbers are not an issue. Forcing customers to register then have us change his customer group is a clumsy two-step process. I was exploring the idea of setting up a promotional code for members and have CC set the customer group immediately, but don't see a way to do that.
  8. citabriabob

    Two prices per Product

    I am testing CubeCart looking for functionality. Checked throught the forums and extensions, but cannot find a way to handle Member/Non-Member pricing. These are both fixed (not %) and activated by possibly entereing a member ID. Any one know?
  9. citabriabob

    Credit Card Capture

    Testing new store; 1) c.c. number is not verified 2) no field for security code Sorry, did not read the documentation correctly; verification and security code are now enabled. However, card number is not accepted if dashes are included between number blocks, i.e., 5111-2222-3333-4444
  10. I have been trying to install CubeCart to see if it's the solution, but cannot get past the database setup. In conversations with the host help desk, they see a period, even though I'm entering underscores on the database name and user: typeclub_NewStore, typeclub_bcc. Did this umpteen times with the same result. Just looked at the error_log and found this: /home/typeclub/NewStore.typeclubs.org/setup/setup.install.php on line 97 [03-Feb-2018 20:00:39 UTC] PHP Notice: Undefined index: config in /home/typeclub/NewStore.typeclubs.org/classes/debug.class.php on line 392 [03-Feb-2018 20:00:39 UTC] PHP Warning: mysqli_options() [<a href='http://docs.php.net/manual/en/function.mysqli-options.php'>function.mysqli-options.php</a>]: Couldn't fetch mysqli in /home/typeclub/NewStore.typeclubs.org/setup/setup.install.php on line 99 [03-Feb-2018 20:00:39 UTC] PHP Notice: Undefined index: config in /home/typeclub/NewStore.typeclubs.org/classes/debug.class.php on line 392 [03-Feb-2018 20:00:39 UTC] PHP Notice: Undefined index: dbhost in /home/typeclub/NewStore.typeclubs.org/cache/skin/d8adaf125878213661fb9e11abee12b13d8e030b_0.file.skin.install.php.php on line 198 [03-Feb-2018 20:00:39 UTC] PHP Notice: Undefined index: config in /home/typeclub/NewStore.typeclubs.org/classes/debug.class.php on line 392 [03-Feb-2018 20:00:39 UTC] PHP Notice: Undefined index: dbusername in /home/typeclub/NewStore.typeclubs.org/cache/skin/d8adaf125878213661fb9e11abee12b13d8e030b_0.file.skin.install.php.php on line 206 [03-Feb-2018 20:00:39 UTC] PHP Notice: Undefined index: config in /home/typeclub/NewStore.typeclubs.org/classes/debug.class.php on line 392 [03-Feb-2018 20:00:39 UTC] PHP Notice: Undefined index: dbpassword in /home/typeclub/NewStore.typeclubs.org/cache/skin/d8adaf125878213661fb9e11abee12b13d8e030b_0.file.skin.install.php.php on line 210 [03-Feb-2018 20:00:39 UTC] PHP Notice: Undefined index: config in /home/typeclub/NewStore.typeclubs.org/classes/debug.class.php on line 392 [03-Feb-2018 20:00:39 UTC] PHP Notice: Undefined index: dbport in /home/typeclub/NewStore.typeclubs.org/cache/skin/d8adaf125878213661fb9e11abee12b13d8e030b_0.file.skin.install.php.php on line 223 [03-Feb-2018 20:00:39 UTC] PHP Notice: Undefined index: config in /home/typeclub/NewStore.typeclubs.org/classes/debug.class.php on line 392 [03-Feb-2018 20:00:39 UTC] PHP Notice: Undefined index: dbsocket in /home/typeclub/NewStore.typeclubs.org/cache/skin/d8adaf125878213661fb9e11abee12b13d8e030b_0.file.skin.install.php.php on line 228 Seems like it's getting confused by the subdomain??
×