Bakery: Small Shop Module (ORIGINAL TOPIC)

[trippnicki]

Hi again Christoph,

Many thanks for your guidance, I am enjoying experimenting with my first site and using your cart.  As for your last advice to add my own forms by php script at line 400, I have tried but that still seems to be over my head for the moment,

but a more simple question, actually, i do not need a quantity field for my particular check out as all customers would only buy one.  Is it easy to do away with that?

Thanks again , happy new year...

Tripp

[DGEC]

but a more simple question, actually, i do not need a quantity field for my particular check out as all customers would only buy one.  Is it easy to do away with that?

Off the top of my head... You might be able to change the quantity variable to a HIDDEN field type, with a value of 1.

Happy New Year everybody!

[freeSbee]

New Version of Bakery:

VERSION 0.8 (01/03/2008)

• Added option to set a third shipping rate according to specified countries.
• If a customer is logged in, Bakery tries to get his address of a previous order from the DB to prepopulat the address fields.
• The address form has an optional state field.
• The zip code can now be display either in front of the city or at the end of the address.
• Option to set up to 3 different tax rates in the general settings. You can associate one of the predefined tax rates to a single item.
• If a tax rate in the general settings is changed, all the associated item tax rates will be changed too.
• Added more CSS classes to the html and frontend.css file to give more control about the shop design.
• After payment has been completed or order has been canceled, Bakery will not kill the session and logged in users will not be kicked out any longer.
• Deletes DB records of not submitted orders older than 60 days automatically.
• Added a quit order button to the message that is displayed when a user has canceled paypal payment.
• When a page or section gets deleted, the associated images and thumbs in the media directory will be deleted as well.
• Fixed a bug in the main page (overview) caused by a not reseted var in the items loop.  It made for items which had no option showing up the item option of the preceding item.
• Improved the code to eliminate all php notice errors.
• Order date is now saved as time stamp.
• Changed the input name="option_attributes" from maxlength="150" to maxlength="600".
• Changed CSS class .mod_bakery_table_c urrency to .mod_bakery_cart_cu rrency_f
• Deleted sql query that made the bakery settings table searchable.
• Added some missing closing tags like </p> and </td> to the html.

Christoph


DOWNLOAD REMOVED
Please download the latest version from the Bakery Website.

[brent]

Christoph,
This module works nicely and getting better!

I have a few suggestions for the US version of Subtotals page:

Subtotal (total of item prices not including shipping)
Shipping (total shipping cost, not shipping based on)
Tax (show total tax not VAT, VAT not usually used in US, possibly have the option of not showing Tax %, just tax total)

Is there a way to reset the order number?

All in all, a wonderful job of creating this cart. This will really make a difference in making it easy to create ecommerce websites for small businesses.

Much appreciated,
Brent

[freeSbee]

Hi brent

Thanks a lot for your feedback!

Subtotal (total of item prices not including shipping)
Shipping (total shipping cost, not shipping based on)
Tax (show total tax not VAT, VAT not usually used in US, possibly have the option of not showing Tax %, just tax total)

Thank you for the suggestions! I am going to upgrade the english language file!
If you will find more awkward or clunky expressions please help me to improve the language file by sending a PM or posting.

If you do not want to show the tax rate % in the email and on the order summary page you can delete
{$MOD_BAKERY['TXT_INCL']} $f_tax_rate%
in the view_summary file on about line 268 and 448
and delete
$MOD_BAKERY['TXT_INCL']." ".$f_tax_rate."% ".
in the same file on about line 291 and 471.

Is there a way to reset the order number?

Reset the order number (order_id) using a sql tool like phpMyAdmin. Goto the mod_bakery_customer table and delete all rows (or those you do not want any more). Then set auto_increment = 1 and your done.

Best,
Christoph

[DGEC]

Thanks Christoph!

--- Rewrite!

Ok, I've tried the new version.  A few problems/oddities and some ideas/wishes:

1) ERROR when installing (actually, upgrading) to the new version I got a popup (in browser I.E.7, server is RHEL, PHP 4.x, soon to be PHP 5), asking me to review and okay the settings or something like that, with no settings and just an OK box. I clicked OK, the box closed and then something flashed up on the install screen and disappeared immediately.  Not sure what was supposed to be going on there!

2) ERROR when trying to save the General Settings, an error message flashes up:

Warning: implode() [function.implode]: Bad arguments. in /home/[nnnnnnnnnnn/wb directory]/modules/bakery/save_general_settings.php on line 50
Success

although it does seem to have saved the changes.

3) Where does the "Show State" get the state from? Or is that "state" as in country, not state as in province of a country? It *is* an essential part for some tax calcuations.

Not sure what Brent meant, but more flexibility in shipping would be good.

Changes! These are our demands!  Ok... "requests"

1) I see what you meant about choosing the 3 tax rates now. Unfortunately, as far as I know, North Americans must show multiple tax calculations. This stops me cold from using it in any production environment.

The taxes I'm aware of in North America are (grouped approximately by organization level):
- Federal/GST (Good & Services Tax, similar to VAT)
- Provincial/State level taxes - can vary widely depending on the type of item
- City taxes
- Excise/Levies/Fees (individual item adjustment obviously) - may add additional flat or percentage amount to individual items.

These need to be broken out, not summarized into 1 tax rate. There are also some common (but not universal) state dependent adjustments like no provincial or state tax calculated if it is shipped to another state or country. I believe some taxes are not charged for out-of-country orders too.

Hopefully, one more (4) level would be enough for most small business. An override for each item might be needed, but we definitely need the ability to be able to display separate tax calculations independently and cumulatively.

Wrinkles: Some states charge tax in the shipper's state, some charge it in the receiver's state, some in the home state of the company, etc - beyond ability to handle, I'm sure! And then there's the online tax moritorium for the USA...

Oh, and each tax may need to be calucated on either the net purchase total or the previous subtotal.

i.e. in Ontario, the tax calculation must be shown as something like:

Code: [Select]

Subtotal         $10.00
GST (5%)          0.50     ($10 x 5%)
PST (8%)          0.80     ($10 x 8%)
--------------------------------------
Total              $11.30

but in Quebec and PEI, the tax calculations are done cumulatively:
i.e. in Ontario, the tax calculation must be:

Code: [Select]

Subtotal               $10.00
GST (5%)                0.50           ($10 x 5%)
QST/TVQ (7.5%)     0.79     ==>($10.50 x7.5%)    - effectively, 7.875%
--------------------------------------
Total                    $11.29


2. As mentioned, being able to set the tax type terminology in General Settings to something other than VAT would avoid changing the standard language file.

3. Default value of 1 in the order quanity field.  (Which isn't labelled, by the way. Doesn't meet accessiblity standards!  )

------------------------------------------------------------------------

Some more advanced ideas/thoughts and wish list:

1. SKU# - I'd like to have an auto-generated number option here, although the default of the product name works for tiny shops. Having an auto SKU would save a lot of tracking.

2. I'd love 2 or 3 levels of item grouping categories. e.g. Clothing, Men, Shirts.  Electronics, Computers, Brands.  Stuff like that. Should be fairly simple, I think?  Maybe a slots for a "related" category or even items for cross-selling.

3. More complicated one. One nice way to standardize the product selection page is to have those "options" fields as drop-downs on the product page, rather than only on the front-end. I.e. you set them up in General Settings and you use drop-downs when editing the product.  (BTW, I like how you link to the General Settings page - need a RETURN button though!)  On the product edit screen, you would have a table populated with the applicable Option or Feature and Attributes and an "Add Option" button of course.

Hmmm. Eventually, maybe even have default Features for different categories! E.g. Selecting Clothing category would automatically create Size, Colour, etc

4. Multiple pictures. Of course, then we get into a whole mess of "options" there

  Also, Maximum size (with resize down to Max) for the full picture, not just thumbnails (which isn't labelled as Thumbnail size by the way, but excellent you've got that in there).

5. Downloadable items - link to a download gallery page, accessible by only that person when logged in, optionally with X downloads and/or X days to download.

6. Speaking of downloads - need reports - display and/or download.  Orders get emailed to you now, right?  To confirm you got all the email orders though, being able to view and/or download a report or spreadsheet of orders would probably be a good thing.  Although, most other kinds of reports would probably better be served by a real order management system, I guess everybody will have to write the SQL to export to their order/POS system.

Gak. Enough from me! 

[brent]

DGEC,
just a couple of comments

Not sure what Brent meant, but more flexibility in shipping would be good.

To my knowledge this is supposed to be a simple cart for a small shop. In the US a simple summary or total for the shipping charge under where the subtotal is would be adequate. If the customer already knows what the shipping rate is, a simple total is all that is necessary.


Changes! These are our demands!  Ok... "requests"

1) I see what you meant about choosing the 3 tax rates now. Unfortunately, as far as I know, North Americans must show multiple tax calculations. This stops me cold from using it in any production environment.

Americans do not need to show multiple tax calculations on an order request such as this. If for example this was a small shop for selling t-shirts, you would show the cost per item, the cost for shipping, and a single state tax rate if applicable. Other taxes such as Good & Services, and city are usually not seen or even charged to the customers. For services you may have other taxes, but again if you take a look at the mass majority of American ecommerce sites you will not see taxes other than state taxes apllied to the cost. State taxes are variable and usually only applied when a customer purchases an item online from the from the same state that he resides in. I  agree, it would be nice to have several options for shipping, UPS, FedEx, USMail, etc.  My suggestions were stricktly for American ecommerce so what may apply in Ontario or elsewhere may not be applicable here.

But this is supposed to be a simple shopping cart for small businesses. This is starting to sound like you need a solution like Zen cart to handle most of those advanced options.

[freeSbee]

@ DGEC
Thanks DGEC for testing and your feedback.

1) The JavaScript alert says «Please check and click OK». I intended to stop the upgrading script to give you a glance over the database changings and let you check up on the displayed success, warning or error messages. Maybe you're right, it is rather confusing than informative. I will comment it in the next version.

2) Thanks for the hint; fixed this bug.

3) Thanks for all the writing about taxes but take it with a pinch of salt. I am at one with brent though I am not at all into Canadien or US taxes.


Bakery was never intended to either turn WB into a shopping center nor compete with full featured e-commerce software. There is already a wide enough range to satisfy all needs and wishes.


@brent
Many thanks for your comments!


Best,
Christoph

[DGEC]

Say, are you implying I'm long-winded?     Well, I guess you could say I got carried away. Ahem.     Sorry!

(re: OSC/Zen - I like OSS and checked them out for awhile, but they are huge, ungainly, ugly, unsightly messes. I like CubeCart, it's is much nicer, and although only the older version can be used freely now, it's still not very expensive for an operating business. But templating seems much harder than WB for all of them. Somebody here tried to integrate CC and gave up and duplicated the template instead)

I rarely, if ever, get receipts that don't break out the taxes.  I tried to do some research it and it seems very small businesses wouldn't have to break out some taxes but provincial or retail taxes... I can't tell. For ease of tracking and avoid legal complications, I would want to be able to offer both. I hate when people lump things together, anyway, makes me suspicious! (My business is exempt anyway) 

- True, most small businesses are unlikely to have a lot of tax lines, but I know some of the small businesses I deal with do use 2.  For those that want/need it, probably adding one more tax field would be enough.  (those with funny calculations could probably use an effective rate)

- the English on page 3, payment option buttons is improper.  You should say "I will pay with PayPal" for example.
I would suggest something like... "Pay in Advance" and "Use PayPal" for the buttons.

- I've never used PayPal - I assume they send a copy of the invoice to the buyer's email?

- also, are you doing anything with the Quantity field, a bunch of Javascript perhaps? Sometimes there is no visible cursor there. I was trying to click on it, and it looked like it wasn't "taking". But when I typed a number, it showed up, but still with no cursor.

[freeSbee]

Hi DGEC

- the English on page 3, payment option buttons is improper.  You should say "I will pay with PayPal" for example.
I would suggest something like... "Pay in Advance" and "Use PayPal" for the buttons.

Thanks for the hint and your suggestion. Made corrections to the EN.php file.

- I've never used PayPal - I assume they send a copy of the invoice to the buyer's email?

Yes, they do.

- also, are you doing anything with the Quantity field, a bunch of Javascript perhaps? Sometimes there is no visible cursor there. I was trying to click on it, and it looked like it wasn't "taking". But when I typed a number, it showed up, but still with no cursor.

No, no JS at all. Couldn't reproduce it either. Could anybody else?

Best,
Christoph

[apple]

Hi guys, this is a very neat module. I have messing around with Gocart without success. This module gives me all I need. Thank you for sharing it. Why is this mod not available in 'Addons' page?

[xram13]

Hi

Thanks for a great module , I am still testing this, but so far everything works , I only have one comment/question

The option's on my producs have different prices on them. Any way I can include those prices in the calculations of the shopping cart ?

[freeSbee]

Why is this mod not available in 'Addons' page?

Hi applepie
I am still working on it -- but it will soon...

The option's on my producs have different prices on them. Any way I can include those prices in the calculations of the shopping cart ?

Hi xram13
Sorry, no...

ITEM OPTIONS
...
Bakery supports one option for every item as long as the price stays the same for every attribute.

@applepie & @ xram13
Thanks for the catch!

Best,
Christoph

[dhdesign]

Using version 0.8 just downloaded a couple of days ago, I am getting this same error when trying to save the General Settings:

Warning: implode() [function.implode]: Bad arguments. in /home/[nnnnnnnnnnn/wb directory]/modules/bakery/save_general_settings.php on line 50
Success

You responded to the OP with this error that you had fixed it. Is that fix to be included in the next version, or is it possible to patch 0.8 to correct this?

Thanks in advance!

[freeSbee]

New Version of Bakery:

VERSION 0.81 (01/19/2008)

• Changed the way of displaying the order summary:
  
  • Subtotal: Just calculates the total cost of items without any shipping per item.
  • Shipping: Calculates the total shipping costs including shipping per item.
• Added a missing language var $MOD_BAKERY['ERR_INVAL_STATE'].
• Made some corrections to the English language file.
• Replaced the error, success and information icons by new ones.
• Fixed a bug that caused a warning when the user did select no zone country in the general settings.
• Changed the concept of "Proceed Shopping URL" to "Continue Shopping URL".

Christoph


DOWNLOAD REMOVED
Please download the latest version from the Bakery Website.

[doxynder]

Great Module!

really easy to use! one question:

But how can i implement the order_nr in the email?

I need this for the costumers: reason for payment/Verwendungszweck

i tried to implement the "order_id" but all attempts were in vain (in backend)

Peter

[freeSbee]

Hi Peter
Thanks for feedback!

But how can i implement the order_nr in the email?

The order_id is actually sent in the subject of the email.

Best,
Christoph

[doxynder]

Thanks for the fast answer!

i´ve seen the order id in the subject but i also needed it in the email...because i need the reason for Payment with an speciefied number - people shoud know what to fill in.

// Replace vars with values
$vars = array('[CUSTOMER_NAME]', '[SHOP_NAME]', '[BANK_ACCOUNT]', '[CUST_ADDRESS]', '[ITEM_LIST]', '[ORDER_ID]' );
$values = array($cust_name, $setting_shop_name, $setting_bank_account, $email_cust_address, $email_item_list, $order_id);

in the backend i added [order_id]

i really don´t know what i´m doing here, but it works (never done something in php). but i´m trying

peter

[freeSbee]

Hi Peter

// Replace vars with values
$vars = array('[CUSTOMER_NAME]', '[SHOP_NAME]', '[BANK_ACCOUNT]', '[CUST_ADDRESS]', '[ITEM_LIST]', '[ORDER_ID]' );
$values = array($cust_name, $setting_shop_name, $setting_bank_account, $email_cust_address, $email_item_list, $order_id);

Thanks for that -- I will put it into the next version of Bakery.

Best,
Christoph

[freeSbee]

New Version of Bakery:

VERSION 0.82 (01/31/2008)

• Corrected tax calculation for prices including tax (brutto prices).
  Do not use older versions any more due to this error!
• Added possability to use [ORDER_ID] in the email templates.

Christoph


DOWNLOAD REMOVED
Please download the latest version from the Bakery Website.

[erikp01]

Christoph,
I just did the setup of the 0.82, now I see that the shipping is not added to the total.
I am working with domestic and abroad.


erik

[freeSbee]

Hi erikp01

I did not change anything about the shipping... !?

What value do you have set for "Free Shipping over:" in the "Shipping Settings" section of the Bakery "General Settings"?

Best,
Christoph

[erikp01]

Christoph,

OK this is it, it must be set to a higher amount.
Everything works fine.

thnx
erik

[erikp01]

Christoph,

I think the button VIEW CART should be visible during the whole shopping process.
This can only give more confidence to the customer.
What do you think?


erik

[freeSbee]

Hi Erik

I think the button VIEW CART should be visible during the whole shopping process.

What exactly would be your suggestion? To show a VIEW CART button on step 1 to 3 of the submit order pages?

Best,
Christoph