[alibey]

topic now should be closed. thanks guys!

[alibey]

updated woocommerce and atelier. everything working fine. cheers.

[alibey]

of course part of this is how woocommerce uses mysql to store product catalog info

i have examined in detail the wp/wocommerce schema and am actually horrified at the design of this database

my background is hi volume hi transaction wall street trading systems where you have complex bond universes etc that have to data modeled
much more complex than anything you see in wp

i would say whomever designed this database knew almost very little about sql normalization/denormalization of professional quality hi performance transactional databases

they just came up with some kludge to model posts and store textual data and images and the rest is history

i would say part of the slowness problem is that… no question.

[alibey]

if atelier is doing this, they need to fix it.
along with optimizing the js by a factor of 3

[alibey]

typo: weren’t

[alibey]

so if atelier or ajax or the plugin is removing the no follow directive then
i have to manually change the permalink to give my client a shot in google SERP in this space

or am i am not understanding. yes I shouldnt have to do this, but it looks like i have to.

this is beyond brain damaged: as if populating a catalog were enough mind numbing work.

[alibey]

yes i am running Version 2.0.13
so maybe that means the the crawler will not follow the link that is attached to the wishlink icon
clicking on this link takes you to the dedicated wishlist page for each use

which is fine but not fine if this then makes google think the site is about wishlists
because i have not keyword stuffed “needlepoint” (what this site sells) into all the titles posts etc

but what seems to be happening with the google spider is that when it goes to a product page
it encounters these icons and then somehow picks up the keyword “wishlist” somewhere in the complex js cart overlay (i could not find the word wishlist in any regular href link for the cart or wishlist) and that is probably what it makes it think my site is about wishlists

my solutions is to manually modify each permalink in the catalog
which is a royal bloody plan in the arse

but my customer is actually in the business of trying to sell something not just have a good looking site that google thinks is about wishlists

so my solution looks like this

The permalink SEO method

where i have changed the permalink + added boilerplate text in the description that stops just this side short of keyword stuffing
when finished with this laborious tasks I shall resubmit to google fetch and have it crawl all catalog sublinks (ie all the products)and hope it ignores the no follow wishlink one

then i will recheck if google still thinks site is about wishlists

cor blimey… not what i thought i would be doing on a sunday morning

the other solution if to disable YIT wishlists entirely
or going with the paid woocommerce wishlist plugin, but good luck with getting support from those dudes

[alibey]

hang on i will go in and do that right now!

[alibey]

wow. i never thought of that! i will look into this immediately! sorry atelier! not your fault!
thank you tonn! i will look around to see where i turn on the nofollow for wishlist.. my guess is in Google Analytics, yeah?

[alibey]

another possibility is to go into each product there are hundreds of them at this point and do some velied keyword stuff.. i should not have to do this brain damaged tedious manual repetitive tasks..

it is claimed that atelier is spider friendly… i need some help here… can you point me to some app that demonstrates that?
if i see livid it is because the owner of the brick and mortar store is scoffing at my efforts to use atelier and woocommerce to develop a web site that actually generates sales not just look pretty

[alibey]

ah… this is a code editor. i thought so, as in Integrated Dev Env, but was not sure why you needed this.
re supplying passwords etc… i am sorry, but the owner of the site has instructed me that going forward now we are in full production mode that no password or admin ids are to be give out and no further widgets added other than fully supported and tested ones from woocommerce only and of course the atelier widget, as long as we use this theme.

she can live with the behavior of relevanssi for now re skus, which you can see by visiting the site, without needing an admin login credentials.

meanwhile, the css selector that targets the menu drop down box would be most helpful.

thanks.

[alibey]

hi i am not sure what wpide is
but you can verify the issue simply by going to the site, as described in the OP

in the meantime, a heads up on the correct selector to use (see above) would be great.

thanx.

[alibey]

as i await the answer to the Relevanssi question (see prior post), i wonder if i could get a quick heads up as to which selector would allow me to round the borders of the drop boxes for menu items, as per the question above:

In a related matter, what selector should I use to style the menu drop downs?

thanks, guys!

[alibey]

i am hoping to be able to show vids on the hp by tomorrow after an event that is taking place this afternoon at the store. i thought the video player element on swift builder would allow me to link to vimeo. that works, right? i mean that works on ipads, right? google analytics has shown that 50 per cent of our user base is mobile, specifically, ipads.

[alibey]

yes as a final note on this thread, i will also use the SWIFT advert widget to offer search by (or “shop by” as the site’s owner wants all the searches consistently named) the 8 core designers that she wishes to promo in her vendor lineup

so this now means that her catalog can be searched by

1. product name
2. sku
3. vendor

“by price” is not a requirement at this time, but it looks like relevanssi would easily accommodate this simply by adding another custom field to be indexed

this is really really good.

i was really hoping that i could somehow use google search by image to allow the nirvana of all searches… by product design… but google image search is not advanced enough yet to support this

now all i have to is use my laughable sql skills to wrie a cron job that extracts from the woocommerce database the latest users who sign up (incredibly woocomerce does not offer this capability), dump this in a spreadsheet for the site owner, and i think it is safe to say we now have a workable ecommerce site

from a UI perspective i now have to focus on how this looks on iphone and apple tablets as it turns out based on google analytics that 50 per of her user base accesses the site this way with lots of safari browser users which i personally have never tested against

so the owner of the site is actually going to get an iphone (she uses an android galaxy smartphone at the moment)

so i am sure i will be harassing you guys again in the future about iphone related UI issues!

but i hope my extended feedback as to your product has in some measure been a welcome feedback to you guys, and perhaps suggested a future direction re the flyout capability