General

General discussion about YAK…

RSS feed

386 Comments »

Comment by Geren
2007-03-21 07:59:23

I’m trying to get YAK 0.9 working on a site other than the one listed above (http://on30guy.on30xchange.net), and am having a problem in that the database tables are not named beginning with wp_. There is no place in the options to set the “prefix” of the table names. You may want to consider adding this for future releases.

 
Comment by jrbriggs
2007-03-21 12:53:50

I’m already using $wpdb->prefix for yak tables in the PHP files. Which should be set as part of the wp-config.php configuration. So can you give me a specific example that’s not working to look into?

Thanks,
J

 
Comment by Kirk
2007-04-03 09:38:41

I am testing the 0.9 Yak Cart on my new site. And I just had a suggestion or two. I can’t say I understand the ramifications of such suggestions, however the way that options and quantities are entered is a bit confusing, and clumsy to me.

Being able to turn each post into a “product” is an incredibly elegant feature. And I understand that by placing the “post” under the category of “product” converts this post into a product.

However it would be nice to be able to rename the category that converts the post into the product. For those of us who wish not to use products as our defining category. Perhaps an option in the options menu. That way a painter could have “paintings” as the converting category, or a band could have “albums” or something of the sort.

Additionally the way that Price and Title are added to the post via custom fields is such an easy and convenient thing. So my question is why can’t quantity and options be added this way as well?

And Pardon my ignorance if this is completely impossible.

Cheers,

Kirk

 
Comment by jrbriggs
2007-04-04 18:59:54

1. yes, the “product” category could be configurable. that’s a good idea, and I’ll look at adding it.

2. quantity needs to be tied to the options. if you have 10 “small” t-shirts and 5 “large” t-shirts, then you need a quantity for each. I couldn’t see a nice way to add that data using custom fields. Plus I had requests for a single place to control that info — hence the yak products screen.

 
Comment by Alan Rolfe
2007-04-26 07:38:47

Hi

This sounds like it has great potential but unfortunately I can’t get it to work. I get an error:

WordPress database error: [Unknown column 'p.weight' in 'field list']
select c.cat_ID as cat_id, c.cat_name, c2.cat_name as parent_name, p.quantity, p.weight, p.dl_file from wp_post2cat pc, wp_categories c left join wp_yak_product_detail p on p.cat_id = c.cat_id and p.post_id = 33, wp_categories c2 where pc.post_id = 33 and pc.category_id = c.cat_id and c.category_parent = c2.cat_id and c2.category_nicename = ‘products’ and p.quantity > 0

..both on the post/product (only one so far (see http://www.ardpix.co.uk/pblog/?p=33 and go to “comments/details” and when I click on Manage>yak>Products.

It also tells me that the item is out of stock but I don’t know how t oadject the stock levels and the “Buy” button does not display.

Hope you can help!

Thanks

Alan

 
Comment by jrbriggs
2007-04-26 21:35:21

Yikes. Looks like a missed a column in the product detail create table, which causes a problem for people installing for the first time.

Can you run this sql command on your database:

alter table wp_yak_product_detail add weight int;

That should fix the problem, and should also allow you to now update the stock levels.

Let me know how it goes.

Comment by Lauren
2008-01-14 19:54:10

OK I got it to work, but it did not work with a different name for a product category, even though it was listed in the settings.

Perhaps the slug has to be the same as the name?

 
Comment by jrbriggs
2008-01-15 07:17:05

I think the slug probably is the important value. I can’t double-check because I don’t have access to my machine at the moment.

 
Comment by Lauren
2008-05-06 01:08:42

I’m moving to another site with the new version of wordpress, well 2.5, and it won’t work now. There is NO such table, wp_yak_product_table….

And the tables in this installation all have their own nickname wp_##### And I tried wp_#####_yak_product_table to no avail.

 
Comment by jrbriggs
2008-05-06 01:20:18

This is (hopefully) fixed in the forthcoming release. Send me your email address (see the Contact page) and I’ll send you the zip file.

 
 
Comment by Alan Rolfe
2007-04-27 08:26:54

Thankss for the prompt response; I do appreciate it. That has solved the error problem.

However, I can’t find how to update the stock position, the weight or the type (whatever that is).

If I go to Manage>yak>products, I can see the three products that I have selected to sell at the moment and I can see editable fields for “Title” and “Price”, followed by button “…”. Clicking on that, just brings up a header with “Type”, “Quantity”, “Weight” and “Download file” but I can’t see how to edit any of these values.. no boxes are displayed. Do I need to create addtl. custom fields on each post for this information? If so, what are the fields called? Or can I do it at SQL level somewhere?

I’m sorry to ask, but hope you can help!

Thanks in anticipation.

Alan

 
Comment by jrbriggs
2007-04-29 23:38:17

What I think is missing is assigning your post (i.e. product) to the default product category.

If you go to Manage>Categories and create a category “products”. Beneath that category, create another category “default”. Edit your post, and then select the “default” category.

Hopefully you should then see the additional data entry rows in the products screen.

Comment by Lauren
2008-01-14 19:50:28

This did not work for me, I have it correct.

 
 
Comment by Alan Rolfe
2007-04-30 09:24:42

Brilliant! Yes, that’s fixed it. Ummm, I guess it was probably a case of not RTFM properly!

Thanks very much for your help and for making the cart available.

 
Comment by jrbriggs
2007-04-30 13:54:49

Might not be a case of RTFM. I haven’t updated this page to reflect the latest changes to support multiple options. Will have to do so now… ;-)

 
Comment by Richard Brown
2007-05-03 07:12:30

Hi

Uploaded plugin and installed fine on 2.1.3. However, if I click Yak in manage I don’t see any configuration options. Below the menu is just a white screen.

Any ideas please?

Thanks

Rich

 
Comment by jrbriggs
2007-05-03 11:24:26

Do you have any error messages in the apache log file?

Please note, I’ve just uploaded rc2, because there was a problem with rc1 (the product detail table wasn’t created correctly).

It might be worth running the sql script “upgrade_0.9_to_1.0.sql” to see if that fixes your problem…

 
Comment by Luke
2007-05-03 22:14:55

I’m testing YAK 1.0RC2 on my Wordpress 2.1.3 site. YAK looks like exactly the solution I’m looking for. However, I’m having a hard time getting the ‘Buy Now’ button to display, using either the PHP code or the comments code.

As far as I know, I’m doing everything correctly: I’ve filled in the options, I’ve set the post to the Default category (a subcategory of Products) and I’ve entered yak_price and yak_title for the post. What am I missing?

If it matters, when I look at the source of the outputted page, the entry says <!–yak_buy–<, as though it were completely unprocessed. However, yak_checkout does seem to work (it displays “You have no items in your shopping basket”).

Any suggestions would be greatly appreciated!

 
Comment by Richard Brown
2007-05-04 18:48:06

Hi

I updated to rc2 and ran the script as suggested - still getting the blank page.

Do you want to take a look?

Thanks

Rich

 
Comment by jrbriggs
2007-05-06 19:30:15

Luke: I assume the angle bracket at the end of “<!–yak_buy–<” is a mistype? Can you try the 3 part versions of outputting the buy button:

<!–yak_buy_begin–>
<!–yak_buy_content–>
<!–yak_buy_end–>

Rich: I’d be happy to take a look. Email me (see the Contact page for the details).

 
Comment by Luke
2007-05-06 19:48:59

Yes, the closing bracket is a mistype. The three-part version doesn’t seem to work, either. Also, yak_price doesn’t display anything in the post. I’ve tried switching Wordpress themes (just in case), but no go.

It’s weird. I’ll send you an e-mail, too.

 
Comment by jrbriggs
2007-05-07 13:19:06

For those interested, Luke’s problem appeared to be an incompatibility with a Paypal donation plugin.

 
Comment by Hone
2007-05-09 15:08:27

Dude you totally rock! This is way better than the other shopping cart plugin made in New Zealand.

 
Comment by Heikke
2007-05-24 09:08:50

Hi there,

I’ve got the same problem as Luke (1.0 RC2 on WP 2.1.3) and there’s no Paypal donation plugin activated … if I look at the source code, i find the form, but the button doesn’t show up.

What else can it be?

Thanks
Heikke

 
Comment by jrbriggs
2007-05-25 20:21:02

Any other plugins installed?

If you view the source of the page, do you see the tag for the button (e.g. <!–yak_buy–>

 
Comment by Božena Malinová
2007-05-29 11:20:59

Hi Jason,
I am running yak 1.0 RC2 on WP 2.2 and using pages rather than posts to display product information.

I can see only “out of stock information” and can not alter quantities in the admin. Inputs for Type, Quantity, Weight and Download file are simply not displayed.

I would also prefer to display buy button even if there is no quantity information for the stock.

Thank you for your help

 
Comment by jrbriggs
2007-05-30 22:32:28

There’s a problem with using pages for products in the current release.

It’s resolved in the 1.0rc3 release (forthcoming). Bear in mind though, that you cannot have multiple types of a single product if you use a page.

 
Comment by Božena Malinová
2007-05-31 06:46:12

I do not need multiple types to sell my stuff at all. That is great. We sell herbs, tees and stuff like that and prices are per 100g pack.

I’ll send you also Slovak and Czech language packages and report all the stuff I come across.

When can I expect 1.0rc3 release?

 
Comment by Jane
2007-05-31 08:52:33

May I use this program without a price? I.e., I plan to use it to allow readers to place a “product” into their basket to create a sort of wishlist. Because I don’t sell anything, I don’t need to identify a price. I wondered if that was going to be a problem.

 
Comment by jrbriggs
2007-05-31 14:36:12

You can probably put the price as 0.0 and then don’t use the <–yak_price–> tag in the post…

Not 100% sure it will work, but worth a try.

 
Comment by Ciobi
2007-06-01 03:57:23

Hello! I’m testing yak 1RC2 on my wordpress-2.1.3 and I’m experiencing a similar problem as Heikke. I’m adding
to the post which I add in a subcategory of products, and the price is shown in the post, but the buy button not. When I look in the source code I do see it replaced with form name=”buynow” action=”/wordpress/index.php#buynow_button” method=”post”>

 
Comment by Ciobi
2007-06-01 08:13:10

An manage - yak - products table remains empty even after I add a post in the product category. A screenshots version of the installation and using process would be very helpful in the future :)

 
Comment by Jane
2007-06-01 15:46:47

I am having troubles having the buy link showing up as well. I am using wordpress 2.2. The product shows up in the Product page, but the buy link does not appear.

When I look at the “view source”, it shows this

It seems to me that my buynow_botton would not be at that path.

 
Comment by Jane
2007-06-01 15:50:49

shoot

form name=”buynow” action=”/index.php#buynow_button” method=”post”

/form

 
Comment by Jane
2007-06-01 16:35:50

I think I have figured out the problem but I don’t have a solution. I use a static front page, and the

$_SERVER[PHP_SELF]

outputs /index.php, when I need it to output something else. How can I code it correctly so that it goes to the yak/images/ folder?

 
Comment by jrbriggs
2007-06-01 21:29:43

Seems like 2 separate problems.

Problem 1: the action in the form is pointing to the wrong place (if I understand correctly).

Problem 2: the html for the button (& image) isn’t appearing inside the form if what you’ve copied is accurate?

How are you setting up the static front page? A plugin?

 
Comment by jrbriggs
2007-06-01 21:45:15

Secondary question, assuming you’re using the built-in WP functionality to create your static front page, how are you including the products?

 
Comment by Jane
2007-06-02 00:34:37

I’ve used the built-in WP functionality (i.e. creating a page) and then pointing to it, but it really isn’t a page because it runs the loop.

I include the products by utilizing the custom field. I.e., I put in the two custom fields - yak_price, yak_title.

I did this for one of the books, and it shows up in the product page.

Here’s the link to the product.

Weirdly, the shopping cart shows up just fine on my static home page.

 
Comment by Jane
2007-06-02 02:17:38

I’ve done a little editing

I changed

. $_SERVER[PHP_SELF]

to
. get_bloginfo(’url’)/wp-content

and got this warning:

Warning: Division by zero in /home/16075/domains/romanticadvances.com/html/wp-content/plugins/yak/yak.php on line 525
0#buynow_button” method=”post” /form

 
Comment by jrbriggs
2007-06-02 11:52:11

The reason you got the division by zero, is that you’ve included a url path (/wp-content) outside of some quotes, where you should have put that after the quote (just before the #buynow_button).

In any case I don’t think that’s the right solution, but I’m not quite sure I understand exactly how you want it to work. It sounds like when you click the buy link you always want it to go to your custom home page? Should that still be the case even if someone is viewing the product page (i.e. not the home page)? Because that’s what will happen if you change that code.

Can you email me the static front page you’re working with. I can try it out on my test server and see what’s going on (no promises as to how quickly I can get back to you though)

 
Comment by jrbriggs
2007-06-03 10:20:56

By the way Božena, apologies for not replying to your last comment.

The 1.0.0rc3 release is basically ready to go, but I have to test it more.

If you feel like testing, send me an email and I’ll send you a zip file.

 
Comment by John
2007-06-04 03:58:22

I installed this plugin, but there is no “Yak” under options in the admin menu.

I am using WP 2.1.3 with Yah 1.0.0rc2

p.s is there a live demo?

 
Comment by John
2007-06-04 03:59:35

oops.. I just read the additional informatio for version 1.

but still would love to see a live demo

 
Comment by Manuel
2007-06-07 03:29:28

Hello Jrbriggs,

I have the same problem as Bozena - can you please send me the rc3, so that I can test it on my wp 2.2?

Thanks a lot!

 
Comment by otsukare
2007-06-10 20:14:39

thanks, nice plugin!

>Manuel
rc3 works on my wp2.2.

 
Comment by Chandra
2007-06-12 23:35:33

Thanks, nice plugin and used at my online comicbook store. Have a usability problem. I am unable to remove an item from the shopping cart. Setting quantity to Zero removes the item from the equation. But thats not natural for users.

Any idea how this can achieved?

Regards
Chandra
http://www.whitedrongo.com

 
Comment by Andrew
2007-06-13 00:54:08

Hello dude! Nice work! Much better than the e-commerce plugin. Easy to customise.

 
Comment by jrbriggs
2007-06-13 12:35:06

To Chandra: I assume you would like a delete button for removing items from the basket?

I’ve had that request a couple of times now, so I’ll look at adding it in the next release.

 
Comment by Chandra
2007-06-14 04:54:31

Thanks, Jason.

Your plugin ROCKs and am sure it will soon ROLL for my online store:

May I write in a few more “requests”? :)

1. Associate Discount with Category. I can then run Special Editions at 20% off. Or Used Books at 50% off.

2. Paginate the Product list under Manage > Yak. Simple usability issue.

3. Show quantity on the list (without having to expand the row everytime).

4. Allow selection of multiple products and do some batch op like Delete or Hide.

5. Introduce Exchange Rate, so that I can enter yak_price in dollars but display Indian Rupee rates to visitors. I am currently using the Discount variable (my discount + tax + dollar) to show yak_price in Rupees.

Is there some other place one can post feature requests?

 
Comment by jrbriggs
2007-06-14 09:37:51

Good suggestions actually. In reply to each of them:

1. more advanced discount rules will have to wait until after the 1.0 final release I think.

2. The problem with pagination is that it adds a reasonable amount of complexity in development — thus I’ll wait until I get a few more requests from users who think it’s an issue.. or someone decides to pay for the feature… ;-)

3. Can’t show quantity in the list, because it’s linked to the product categories. The only other option here would be to have a setting to make the products page default to display detailed information.

4. See #2

5. Exchange rates are difficult because of currency fluctuations. I would either have to link to a free exchange calculation service (not sure I’ve seen are any of those…?), or the user would have to keep the rate up-to-date manually (which is a bit ugly). If you’ve got any thoughts on that front, let me know. Will probably also be a post-1.0-final feature as well, though.

This is probably the best place to post feature requests, by the way.

 
Comment by Chandra
2007-06-14 21:34:24

Thanks a lot for your interest, Jason. Guess product develops in baby steps :).

About #5 above.. well, am not so sure about other businesses, but booksellers tend to reset the exchange rate once a month, and not everyday. If that is true, then manual entry is fine I guess.

Looking forward to the next release. Hopefully, upgrade should mean just refreshing the php file in plug-ins folder, and no data-structural changes. :)

 
Comment by Luke
2007-06-22 13:22:25

Exciting news — my site just went live! Which means that if I hit any more snags, they’ll be reported by my customers :)

I have one more request. When somebody buys more than one download, it can be hard to distinguish between them, since the web browser wants to save all of the files as “yak_dl”. Is there any way to retain the original filename on the client’s end?

 
Comment by Lisa
2007-06-24 06:38:23

Hello,
I’m a first time user of the instinct shopping cart and wordpress. My problem is with the shipping price for the products. I have added the sipping price under Manage > yak > Settings, but it never shows up. Also I have different shipping rates for different products, so I was wondering how I handle that.
Any help you have to offer would be greatly appreciated.
Lisa

 
Comment by Luke
2007-06-24 16:18:10

Hey Jason,

If I want to clear the database of all orders (i.e., the orders I made while testing), which MySQL tables will I need to go into?

Thanks,
Luke.

 
Comment by jrbriggs
2007-06-24 22:56:22

Luke:
In regard to your first message (download filename), I’ll see what I can do.
In terms of deleting orders, delete from the following tables:
wp_yak_order
wp_yak_order_detail
wp_yak_order_log
wp_yak_order_meta

Lisa:
Shipping is set up either as a fixed cost for a particular country, or by weight per 100gms. If you enter weight cost in yak settings, then you need to specify the weight of your products. Apart from that, not sure what else might have gone wrong.

Oh, and by the way, YAK has nothing to do with instinct.

 
Comment by jrbriggs
2007-06-25 22:49:56

Luke: the problem with the download filename (only in IE as far as I can tell) will be fixed with the next release (rc4).

 
Comment by Luke
2007-06-26 11:26:22

Awesome. Thank you once again!

And I think you’re right: I wasn’t aware of any problems with the download filenames until I started testing the site on my friend’s Windows-based computer.

 
Comment by jrbriggs
2007-06-26 19:51:20

Blimmin’ Windows. Bane of my existence… ;-)

 
Comment by jay
2007-07-04 19:52:03

Does anybody know where i can find a french po file for yak?

awsome plugin, btw! :D

 
Comment by jrbriggs
2007-07-05 10:00:00

You could always translate it to French yourself…. (hint hint).

 
Comment by jay
2007-07-05 19:47:02

I’m just afraid that my french isnt that good at all…so i was hoping somebody already translated it :P
i could even offer a german language file in exchange :)

another thing:
Is it possible to include direct debit in the way credit card is used in the plugin?

thx

 
Comment by jay
2007-07-05 20:34:37

oh and also:
Is there a way to implement staggered pricing?

 
Comment by jrbriggs
2007-07-06 09:16:15

By direct debit, do you mean prompt for an account number?

If so, then not without development effort. The credit card form would need to be modified to allow for that functionality.

Question: what do you mean by staggered pricing?

 
Comment by jay
2007-07-06 23:14:09

hey,
with direct debit I meant, that customers leave their bank account details and the dealer can then substract the money from the customer’s bank account.

and staggered pricing:
That the price for an item decreases if 10 copies are bought, and again at 20 copies, and so on.

 
Comment by jrbriggs
2007-07-09 19:13:22

Understood. Both would require development.

So the short answer is that for the near future, there’s no way to do either.

 
Comment by jay
2007-07-09 19:45:59

SO, when’s the next version going to be online then? :P

 
Comment by jrbriggs
2007-07-09 23:15:06

Soon. Next week or so. Subscribe to the feed (see the top of this page) and you’ll get a notification.

 
Comment by jay
2007-07-13 21:44:04

While waiting for that new release :D, here a question:

When one item is in more than one product category, why is there automatically a dropdown menu in front of the buy button? For what purpose exactly? and how can i remove it? :)
thanks

 
Comment by jay
2007-07-13 22:19:01

hmm one more thing i cant seem to figure out:

In the checkout there is automatically the category of the item written behind the item’s name. How can i remove that? because i am using a language switcher and it’s not working at this point, so all i get, instead of the category name, is all the translations in tags…

thx again

 
Comment by jrbriggs
2007-07-13 23:33:18

Product categories (i.e. a sub-category beneath the “products” category) are for purchasing different types of the same product. i.e. different sizes of t-shirt, different colours, etc. So the dropdown is there to allow the buyer to select the specific type of item (large men’s t-shirt for example).

If you only want to categorise a product for filtering or searching for products (and don’t have different types of the same product), then don’t use sub-categories of “product”. Instead create categories at the root level and assign to your product post.

In which case, beneath the “products” category you should have a single category called “default”. Assign your product to that (and no others) and the dropdown will vanish, plus you won’t get the category name in the checkout.

Hope that helps.

 
Comment by jay
2007-07-14 02:21:29

thanks, that worked perfectly! except, that the categories, as they are shop categories, are still displayed behind the items name in the check out :(

 
Comment by jay
2007-07-14 12:36:43

Just a little note aside:

When you move an item from on shop category to another one, the item looses its quantity, so you have to reset it in the yak settings…

 
Comment by jrbriggs
2007-07-15 11:16:46

Can’t reproduce that. I’ve set an external category (i.e. not a subcategory of “products”) to a product and, in the checkout, that name is definitely -not- displayed.
Not quite sure what you’re doing wrong there — or I might’ve misunderstood what you’re trying to do.

Subcategories of “products” (the values that appear in the drop down when the user buys a product), are supposed to appear in the checkout (by design). That way if someone buys a large T-shirt (for example), in the checkout they can see that.

In regard to your second note, that’s correct — there’s no way to “move” an item from one shop category to another (it doesn’t make a lot of sense from a real-world perspective either).

 
Comment by mtk
2007-07-16 19:41:06

Hello everybody, hi Jason,

I’m using RC3 and i tripped over a mysterious one: if you order an Item say 10 pieces and it’s only 1 on stock, then you get the out of stock message. But after displaying this error message the shipping cost is 0 (zero). And, by the way, the count of items in the shopping cart is not changed. Any hints?

Greetings

Marcus