colorful-ant
-
Posts
577 -
Joined
-
Last visited
-
Days Won
10
Content Type
Profiles
Forums
Gallery
Downloads
Articles
Store
Blogs
Posts posted by colorful-ant
-
-
another example with variants
SELECT m.name AS manufacturer, p.id_product, pl.name, GROUP_CONCAT(DISTINCT(al.name) SEPARATOR ", ") AS combinations, GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") AS categories, p.price, pa.price, p.id_tax_rules_group, p.wholesale_price, p.reference, p.supplier_reference, p.id_supplier, p.id_manufacturer, p.upc, p.ecotax, p.weight, s.quantity, pl.description_short, pl.description, pl.meta_title, pl.meta_keywords, pl.meta_description, pl.link_rewrite, pl.available_now, pl.available_later, p.available_for_order, p.date_add, p.show_price, p.online_only, p.condition, p.id_shop_default FROM tb_product p LEFT JOIN tb_product_lang pl ON (p.id_product = pl.id_product) LEFT JOIN tb_manufacturer m ON (p.id_manufacturer = m.id_manufacturer) LEFT JOIN tb_category_product cp ON (p.id_product = cp.id_product) LEFT JOIN tb_category_lang cl ON (cp.id_category = cl.id_category) LEFT JOIN tb_category c ON (cp.id_category = c.id_category) LEFT JOIN tb_stock_available s ON (p.id_product = s.id_product) LEFT JOIN tb_product_tag pt ON (p.id_product = pt.id_product) LEFT JOIN tb_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN tb_product_attribute_combination pac ON (pac.id_product_attribute = pa.id_product_attribute) LEFT JOIN tb_attribute_lang al ON (al.id_attribute = pac.id_attribute) WHERE pl.id_lang = 1 AND cl.id_lang = 1 AND p.id_shop_default = 1 AND c.id_shop_default = 1 GROUP BY pac.id_product_attribute -
sql query products simple (but can change for more)
SELECT p.id_product, p.active, p.price, p.id_tax_rules_group, p.wholesale_price, p.reference, p.supplier_reference, p.id_supplier, p.id_manufacturer, p.upc, p.ecotax, p.weight, p.quantity, p.available_for_order, p.date_add, p.show_price, p.online_only, p.condition, p.id_shop_default FROM tb_product p GROUP BY p.id_product -
@vincentdenkspel
BO (KATGORIEN/category) - sql query u can try this ;)
``` SELECT a.
id_category,active,name,link_rewrite, a.id_parent, a.is_root_category,description,meta_title,meta_description, a.id_shop_defaultFROMtb_categorya LEFT JOINtb_category_langb ON (b.id_category= a.id_category) LEFT JOINtb_category_shopsa ON (a.id_category= sa.id_category)
WHERE 1ORDER BY a.
id_categoryASC ``` -
@vincentdenkspel
im not sure, but try "the mass edit toolset" from @musicmaster - its great for some exports ( not all is free) https://forum.thirtybees.com/topic/925/prestools-the-mass-edit-toolset
or try the module from @datakick
-
bei mir hat es funktioniert - hast du deinen shopcache und browsercache etc. geleert? wenn der shop nicht aktiv ist -> deaktivieren von cache & co
-
sorry have not read correctly -> block
@vsn - please look here - i think this can help https://forum.thirtybees.com/topic/870/change-the-productcategory-module/8
-
Do you mean this?
EDIT: sorry have not read correctly -> block
-
-
i´m not sure, if it will help you - i use only 1 country with free shipping from price x other countries have another carrier-setting, not the same compare my image with your first image ;)
-
I have not tested it for your question, maybe the TB module "Custom Payments" is helpful too https://store.thirtybees.com/shop-modules/payment/custom-payments
-
thanks - now i understood it better
-
It's probably too late for me. I hope this helps:
Option 1 Usually it should be enough if you change the customer's e-mail address in the customer data, if the e-mail is generally wrong
Option 2 manual order and incorrect order data customer entered -> cancel and create a new order with the correct data (if necessary adjust in the database, such as the date)
Note: manual order slowly perform -> if customer data is available, wait until they appear (usually there is already a shopping cart, if this is right to select or create a new) - possibly before in the customer account (if available) to see if there is already a shopping cart and then carefully transform it into an order
for new ps / tb users please create your own test customer account and try it in the admin area - theoretically it is easy, if necessary wait a short time for entries like mailaddress (name), productnumber (name) etc
-
Sorry, I probably do not understand your request.
I think this topic / question is now obsolete for sellers. Block any potential customers? Anonymous visitors, guest orders, customers who try to hide their IP's. There are other ways to prevent spam etc. I personally do not want to block any customers because of their IP address. Registration with payment ok, then the goods will be shipped. For me, the IP address is absolutely unimportant, name, address and payment must fit. For me as a seller within the EU, privacy is important.
-
SEO Module
in SEO
if you want to change the length
example: for description -> modules / seoupdater / seoupdater.php -> search /* Update product meta_description */
$sql .= ', `meta_description` = \''.pSQL(substr($product['description'], 0, 205)).'\' '; elseif (Configuration::get('SU_META_DESCRIPTION_PRODUCT_TYPE') == 0) $sql .= ', `meta_description` = \''.pSQL(substr($product['description_short'], 0, 205)).'\' '; elsechange 205 to your wish characters 215,250,340 or another number
-
SEO Module
in SEO
@AndyC you can test this module with my changes - its your own risk but if you save it -> delete number etc from name before seo.... or rename it to "seopupdater zip" before you install it
-
@Pilou I'm not sure I understand it correctly. Does the customer have to register separately in the shop so that he can use this function?
I also use the module, a registration is not necessary for me. no matter if already registered customers or even simple visitors can be informed with me, as soon as the product is available again.
EDIT: i think some users from tb use the mailalert-module and it works with and without registration only the option with additional module "customer out of stock" i need me own changes to see the date in the list
-
do you use "Google Analytics API" module? i dont know - i dont need it
-
i´m not sure "client secret" etc? my settings only with the tracking id - and it works simple standard - or you have/use the false module
-
why do not use the thirty bees module "Google Analytics"?
-
@30knees
sorry für die späte antwort auf deine frage/kommentar - ich mußte bzw bin weiter am testen mit dem ps-paypal, tb-paypal 5.3.x und ab morgen evtl die tb 6.0.4 oder so. mir persönlich ist es gar nicht so aufgefallen (abgesehen von den bestellungen - was manchmal diverse gründe haben kann - konkurenz ist günstiger, schlechteres google-ranking etc)
nachdem ich die änderungen vorgenommen habe, scheint es tatsächlich besser zu laufen und die aussetzer scheinen momentan nicht mehr orhanden zu sein, das
ich habe vor ca. 2 wochen den link in meinem letzten kommentar hier im thema gesendet, nun scheint einiges veschwunden zu sein mit der lösung da der topic nur bis #6 funktioniert (im link ist minimum #13 angezeigt) mit der gleichen lösung konnte ich ein anderes problem lösen, auch hier ist die verlinkung die gleiche https://forum.thirtybees.com/topic/2129/unknown-column-idaeucemail-in-field-list/5
jetzt wo ich diese lösungen dazu nicht mehr sehe, finde ich es sehr schade für andere user die evtl ähnliche probleme haben
-
have you cleared your shopcache and browsercache? or delete class_index.php
-
have you debug mod on?
-
bislang habe ich mit tb zu deiner frage keine probleme. wenn du eine liveseite hast, die auch schon im google-index ist, dann google mal nach ihr. falls du es nicht kennst - gibst du im suchfeld ein:
site:meinedomain.de (http/s: eingabe ist nicht notwendig)
-
please show under modules and services -> payment
scroll down - more options for payments country and carrier active for paypal?
other options - activate bankwire and set up for test - same problem? - https for all pages active? - .....
Best way to export and import: products, categories and images ?
in English
Posted
I do not know which prefix is in your database "tb" or "ps" or another