30knees

Update: datakick fixed the table issue. On 1/9/2023 at 8:16 AM, Daresh said: Actually the module helped to discover a ThirtyBees bug in a customer counting function. I just got the module and received an error upon installaton. This is the error: Not unique table/alias: 'c'in file /classes/Group.php at line 437SQLSELECT COUNT(*)FROM `tb_customer` cLEFT JOIN `tb_customer` `c` ON cg.`id_customer` = c.`id_customer`WHERE (cg.`id_group` = 1 ) AND (c.`deleted` != 1) LIMIT 1 Is this the bug you mentioned? What would I need to do to fix this? I'm also getting this error log: Notice Trying to access array offset on value of type bool modules/gm_omniprice/gm_omniprice.php:464 80 Today 10.02.2023 12:57:18 Notice Trying to access array offset on value of type bool modules/gm_omniprice/gm_omniprice.php:465 80 Today 10.02.2023 12:57:18 Notice Trying to access array offset on value of type bool modules/gm_omniprice/gm_omniprice.php:535 80 Today 10.02.2023 12:57:18 Notice Trying to access array offset on value of type bool modules/gm_omniprice/gm_omniprice.php:536

Does that make sense, no invoice without a payment? It depends on your type of accounting but it feels like it shouldn't be decided by the shop.

Correct, I have a module to edit orders. 🙂 But I guess that's still independent of the issue that when one generates an invoice the system thinks the order was paid (even if you don't change the order state to a state that is paid but leave it unpaid).

I discovered that when one generates an invoice the system thinks the order was paid (even if you don't change the order state to a state that is paid but leave it unpaid). This is the order total that shows up above as 431,95. I edited the order I had generated the first invoice because the customer requested some changes. I then deleted the old invoice and generated a new one. The 431,95 was taken from the old invoice.

The reason I'm asking is because an invoice I opened shows two different totals, see below. I don't know where the price discrepancy would come from. I edited the shipping price from 20 to 18.18, but that's not the difference between the two totals.

No, no overrides. I'll check again after the update to 1.4 and report back.

Sure! This has been with thirtybees since the beginning and is still in 1.3. I have a product variant that has a specific price of -4% when a customer takes for example 5 of them. See here: Problem: The specific prices override any attempt at manually setting the price when I manually create an order in the backend using "Add new order". For example, maybe because it's a special customer, I'd like to give them a one time price of 1 Euro per item for instead of the normal price of -4% for 5pcs. So I enter a different price on the manual order page in the backend after choosing the customer and the product. However, the system doesn't accept the manual price for the 5pcs I'd like this order to have. Instead, it reverts to the the special price of -4% for 5pcs. I see that @Smile commented he has the same problem with specific prices for customer groups.

Some more specifics. One can manually set a price when editing an order (just not during creation of the order), but the price can't be 0.

Ah, good point. It's the first time I'm seeing encrypted modules. Will pay attention to this going forward.

@datakickWas this issue ever addressed, by any chance? EDIT: It's not in 1.3.

Looking forward to the update! 😄

In case someone is looking: a module that permits this: https://addons.prestashop.com/en/price-management/53088-same-price-products-and-shipping-after-vat-applied.html

Just in case someone is interested: https://prestashow.com/en/moduly-prestashop/85-product-price-history-prestashop-omnibus.html (if for some reason Daresh's is no longer available).

Hi @veganline, is Storemanger still working with the latest tb?

The specific pricing feature is not very user-friendly. You can't edit prices, you have to delete an old price to update it, and if you work with variants it's lots and lots of clicking. What do you do to make your life easier? Is there some way to handle this better?

Eric Jones, he's our biggest fan. 😂 We just started using mediacom's module.

Hi, I think I discovered a bug. The module seems to ignore taxes from shipping costs. Here are two screenshots for the same order. One shows the invoice where you can see the taxes for the articles ordered and for the shipping cost. The other shows what the module reports. You can see that the module does not report the shipping costs. Invoice Module

Good news: Panda will be updated for tb! https://www.sunnytoo.com/forums/topic/has-thirtybees-been-abandoned#post-145738

I wasn't aware of that, thank you. Which module do you use? I see there's one from MaxMind that's the tb default one.

It even looks like they're no longer supporting PS 1.6 officially. I'll start looking into Niara, I think.

It's only for countries. It's true that calculating based on a fixed net price is easier / safer. But there isn't such a massive difference between the VAT rates that a sale would no longer be economically viable. Still, datakick's module would 'fix' the problem of customers being surprised.

Yes and yes.

Yes, something like your module was what I had in mind. As you said, mostly people don't log in / select the sihpping address before the checkout. This issue actually came up yesterday. A customer wrote saying the price changed when she went to the checkout and she was wondering whether it's because of taxes in her country.

I hadn't thought about that but I don't think this particular scenario qualifies as price discrimination. It's an objective factor and it's about distance selling between countries, which is treated differently. That being said, there should be a way for a shop to show the price dependent on delivery to a certain country, for example because the visitor, without being logged in, can select "Greece". Alternatively, it would be great to have the net price change but the gross price stay the same). @e-comAre you aware of any ways to achieve one of the above?

Currently, prices for B2C customers are shown including VAT. This is good. However, when a customer goes to check out and they enter their address, the price shown to the customer will change because of that customer's country's VAT rate being different AND because (my) thirtybees does not change the net price of the product excluding VAT, but the gross price including VAT. I thought we had a setting that permitted us to keep prices for the customer at the same gross price, regardless of their VAT rate. Am I remembering something that actually never was?