colorful-ant

I do not know which prefix is in your database "tb" or "ps" or another

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_default FROM tb_category a LEFT JOIN tb_category_lang b ON (b.id_category = a.id_category) LEFT JOIN tb_category_shop sa ON (a.id_category = sa.id_category) WHERE 1 ORDER BY a.id_category ASC ```

@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

rm 12 -30 % => 8,40

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.

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)).'\' '; else change 205 to your wish characters 215,250,340 or another number

@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 01543361971412seoupdater.zip

@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? - .....