Invoice messed up

[Manisch]

Good morning,

I have an invoice issue. Some information is missing like the customer's address or the logo. Other lines seem to take the data from ALL orders like the payment method.

They were displayed correctly a few days ago and I think the only thing that could have effected them should be the migration/import of old customers and orders. But looking to the backoffice, they "should" have been imported correctly.

Any ideas? :D

[SLiCK_303]

I've had the same thing happen to me! What version of paypal are you using? What version of php? We need to get this figured out!

[Manisch]

PayPal 3.11.4 PHP 7.1.15 ThirtyBees 1.0.4

[SLiCK_303]

thats sounds like a PS version of the paypal module... I use.Paypal 5.3.2 PHP 7.1.15 thirtybees 1.0.3

[Manisch]

That is correct. It's a migration-shop, so I wanted to play it save somehow. But I'm not sure it's about PayPal since other stuff is missing, too. And the example above is via bank wire.

[SLiCK_303]

so its a core issue.. weird. Saidly I dont think it's possible to recreate this error, it just seem to be random. @mdekker needs to look into it, but without being able to reproduce the error, its going to be impossible to fix. :smirk:

[Manisch]

That doesn't sound much promising :(

Can you show us a sample invoice of your shop?

[SLiCK_303]

It looks the same as yours, but It's too long to show, it was a 5 page order, with 17 pages of Payment Method... The only thing different about it is, that on page 4 it shows the correct total, with two of those payment methods showing. Then the next page it whose the total for 1 product, then 17 pages of payment method.

[Manisch]

My invoice goes over ~5 pages, but I only posted the first one :D

Did you start your shop from scratch, or did you also import customers and orders?

[SLiCK_303]

Clean install, then imported stuff

[zimmer-media]

@manisch

I use a separate template from eleazar. Adapted to TB with the help of mdecker.

[Manisch]

@SLiCK_303 so we have in common that we both imported customers etc? How did you do it? Directly via database?

@zimmer-media thanks, but the problem isn't the template itself. It's more about how it's filled.

[zimmer-media]

@manisch

Yes I did see it. First and foremost, I would assume that the assignment of the ID's in the database runs together here. eg in the table invoice payment or so etc. - same ID's.

[Manisch]

Hmm, I though I checked it. At least I took a look at tb_orders and it seemed fine to me. Every order still has it's own, unique ID and it's not like a customer can see every order of everyone ever made.

But on the other hand I can only explain this error by some wrong linked database entries. I just don't know where and how to check...

[zimmer-media]

@manisch try to show on tborderinvoice tborderinvoice_payment

[SLiCK_303]

@manisch said in Invoice messed up:

@SLiCK_303 so we have in common that we both imported customers etc? How did you do it? Directly via database?

I did it directly to the database. Changing anything that was different in ps to tb, then exporting my ps database tables, customers, orders, ect., and importing them into my tb database.

[Manisch]

@zimmer-media Still looks fine to me, but I'm no expert in databases. All ID and order-references are unique :/

@SLiCK303 I actually kept the ps prefix. I tried to import the databases but hat troubles to get logins working, even with changing the keys. In the end I used Store Manager for the import. Is your Logo and customer address missing, as well?

[SLiCK_303]

@Manisch no, both my logo and address's are there.

[Manisch]

Ah ok, so there is something else wrong with my invoice :D

[Manisch]

I could still need some help on this one (:

[datakick]

@manisch this really seems like some data integrity problem caused by botched data import. I'd guess data from different tables were incorrectly paired, possibly referencing non-existing documents. I could have a look at your data to confirm this, but it probably won't help you much. It would be hard to fix the data in place - it's probably better to do the import again.

[SLiCK_303]

For me, this happened months after i did my change over to tb. Also many many order afterward as well. It seemed very random, and has only happened once for me.

[Manisch]

@datakick Well, a confirmation of the exact problem would be worth something. So if you're really willing to at least take a look, I won't say no (:

[Manisch]

So as I noticed, it's mostly an issue with older/imported orders.