zimmer-media

https://forum.thirtybees.com/topic/537/index-404-error-after-ps-1-6-1-1-migration/11 "Our migrator does not add them automatically. Its a bug in our migrator. What you will have to do is go to Administration -> Menus and add them manually. For the duplicate urls add what is in the image below. http://storage9.static.itmages.com/i/17/0714/h15000439488281976_ddfa38dca4.png For the css page add what is in this image. http://storage4.static.itmages.com/i/17/0714/h15000440297213616_9e78921359.png Have you checked out the thirty bees developer blog? Want to try thirty bees? Launch a free thirty bees trial on Cloudways"

sorry its german language activ

My first guess is that you have items with the same product name and one of them is disabled. Start the function "duplicate urls".

A separate statistic that displays a table of winning orders in the selected time period. The table can be exported via CSV. Actually created years ago for PS statistics, so far works very well with TB. Please note: If the purchase price of the supplier does not exist in the product, a wrong result is output. The same applies to products with variants in which the possibly higher purchase price is not available etc EDIT: If you do not have any purchase prices because you sell items that are self-manufactured, then enter the manufacturing cost there.

An additional line with a quantity specification is also generated in the order view and on the invoice. On the bill also appears an incorrect quantity. The prices are ok here. -

Many thanks for your response. Damn, of course, I completely forgot to sort fields without values. I always tried filtering for fields without values.

In the order view in the BO, the quantity and the price are not right. The total amount at the end of the order is correct. 2 different orders. - - In a still PS-Shop V 1.6.0.13, the view looks good.

hmmm mark as solved doesnt works perfect

@mdekker ............ Are you already married to TB? This is not only good, more to say PERFECT. Absolutely cool, it works with saving the queries. It's like Christmas - laugh. Very good performance

It's a very helpful tool, we love it because it makes our job a lot easier. How can I filter in the tool, for example, if I want to see entries without values? So that I can enter the missing information. As an example product available, it is not filled in all articles, because it was forgotten when importing CSV.

OK thanks. If I look at the link and see that 123 files and over 12,500 lines were changed - ohh, my god.

That sounds good. I'm just a bit confused, because the queries via PHP in the module work but not in the BO. Or eg here is the problem when saving queries in the BO?

the same error with fresh tb-installation and the tb_ prefix

In my old PS 1.6.1.1 the queries work. Here is another query: SELECT oi.id_order, oi.reference, ROUND(oi.total_paid_tax_incl,2) as totalpaidtaxincl, DATE_FORMAT(oi.date_add, '%d.%m.%Y') as order_date, o.current_state, os.name as order_state, oi.id_customer, c.firstname, c.lastname from ps_orders oi JOIN ps_orders o on oi.id_order = o.id_order JOIN ps_customer c on o.id_customer = c.id_customer JOIN ps_order_state_lang os ON o.current_state = os.id_order_state WHERE os.id_order_state = 1 OR os.id_order_state = 3 OR os.id_order_state = 8 OR os.id_order_state = 9 OR os.id_order_state = 10 OR os.id_order_state = 11 OR os.id_order_state = 13 OR os.id_order_state = 16 AND os.id_lang = 1 ORDER by oi.date_add ASC PS save this query: on TB not:

I have tried this now. Even without the last 3 lines.

ahhh, grrrr, ok Even if I omit the last 3 lines, I get the same error message.

from my testshop new tb installation statistic invoice-list no error with this query

for example: SELECT oi.idorder, oi.idorderinvoice, ROUND(oi.totalproducts,2) as article, ROUND(oi.totalpaidtaxexcl,2) as totalnetto, ROUND(oi.totalshippingtaxexcl,2) as shippingtaxexcl, ROUND(oi.totalpaidtaxincl,2) as totalpaidtaxincl, ROUND((oi.totalpaidtaxincl - oi.totalpaidtaxexcl),2) as totaltax, ROUND(((oi.totalpaidtaxincl - oi.totalpaidtaxexcl)/oi.totalpaidtaxexcl)*100, 0) as tax, DATE_FORMAT(oi.date_add, '%d.%m.%Y') as invoice_date, c.firstname, c.lastname FROM ps_order_invoice oi JOIN ps_orders o on oi.id_order = o.id_order JOIN ps_customer c on o.id_customer = c.id_customer JOIN ps_order_state_lang os ON (o.current_state = os.id_order_state) WHERE os.id_lang = 1 '.Shop::addSqlRestriction(Shop::SHARE_ORDER, 'o').' AND o.invoice_date BETWEEN '.$this->getDate().' ORDER by oi.id_order_invoice ASC migrate shop from ps prefix ps_ new installation tb prefix tb_

When I try to create queries, eg from my statistics modules, to extend or optimize them. Because in the statistics modules, the SQL queries work without problems.

When I create queries in the BO SQL I always get the error "Undefined "checkedFrom" error". The same error with newly installed TB shops or a PS migration. Even with different query attempts. EDIT: if i use another präfix - > error - table does not exist

@mdekker thank you. Should I immediately see the correct prices in the view after the changes of the files, or only after the next order of one of these products? Cache etc is emptied, still get the odd wrong prices displayed. Important for me is not currently, the bills are indeed created correctly. Only at first it looks very strange.

@raptorx said in General ThirtyBees Back Office UX improvements: E.g.: I filter all products to have just all the watches and want to disable them temporarily because I will do something pricewise and don’t want orders coming in for watches in the mean time. For a probably faster processing of the prices I use the mass editor tool of @musicmaster. At this time I do not need to disable any articles. For example, I use this tool to filter a desired category and select the necessary data, eg product ID, title, article number and sales price. Afterwards I export the data into a CSV file and can change these eg by Excel and formulas prices. No matter if the price should increase by 0,50 € or 5%. After processing the file, I import the file normally via the BO. From my experience, you can also make wonderful mass changes with this tool. Not all features are available in the free version, but a very large part is open and it has saved us a lot of work time here. This is just a suggestion to make any work easier.

Is Stripe enabled for the payment methods?

In a still PS-Shop V 1.6.0.13, the view looks good.

Everything is ok on the bill. In the back office, incorrect data / values are displayed in the order view. Customized products with more than one text box. The sales price is multiplied by the number of text fields in the product column. As if the customer had ordered 4x the same product, eg 4 text fields. The total amount of the order is correct.