Recent posts

#31

General Support / IP address iso domain address ...

Last post by 200268am - May 24, 2026, 11:50:31 AM

I am using version 1.3.2 with PHP 8.0.3 for quite a long time now and I really like everything about Abantecart

I lately have stumbled upon an issue that I could not resolve


Abantecart is sometimes using the IP address with http instead of the domain name with https


What happens is that the categories, and sometimes the products, do not show up (the browser blocks the access because it is not safely encrypted with SSL), because the bare IP address doesn't have SSL and is pointing to an http address

So the whole page is showing but the content (categories \ products) is not showing

So for example

http://000.000.00.000/image/thumbnails/26/image1.png

is mentioned instead of

https://mydomain.com/image/thumbnails/26/image1.png


My domain has an SSL and I have tried to apply for an SSL for the bare IP address separately but this is not very simple


In the settings of Abantecart it is properly configured as https://mydomain.com in both fields

The configuration file in system is also properly configured as mydomain.com


The website works properly after dumping the cache but returns to this strange behaviour after some time. I am not sure what triggers it. It also shows up mostly when using the browsers on a mobile phone. It occurs on the laptop but less often


If anyone could help I would really appreciate it

#32

Extension Support / Re: [Possible Bug + Fixes] Pay...

Last post by RCodiaDavid - May 24, 2026, 04:33:32 AM

Hi Basara, thanks for following up.

To answer your questions:
Customer Country: UK
Order Currency: GBP
Paypal Method: PayPal Commerce (standard button on the fast checkout page)
Checkout buttons enabled: No
Product type: Physical goods only

Regarding the specific incident, I have been waiting for payment confirmation from the customer as I don't have access to their PayPal directly. It has come to light that PayPal automatically detected and refunded the duplicate charges, so the customer was not out of pocket.

But to clarify the symptoms further, in some cases the order was created in Abantecart, and payment was taken, but the customer was not redirected to a confirmation page and their cart remained full. This suggests a browser side callback was not completing reliably, leaving the customer with no confirmation even though the order had gone through on the backend.

That said, looking into the issue made it clear that there are some edge cases in the checkout flow worth addressing. The fixes I have applied locally add a reliable fallback for situations where the browser side callback does not complete, for example: if a customer loses their connection or closes the tab after PayPal has taken payment. This ensures the order is still confirmed in Abantecart even if the browser callback fails.

I hope this helps is some way.

#33

Template Support / Re: database issue

Last post by G. O. - May 21, 2026, 04:53:48 PM

Hello.
Products may also be missing from Admin if cache is outdated, or if the product is not assigned to the store view you are checking.

Those names are stored in the product description table. To check them in the database, use your own AbanteCart table prefix from system/config.php (DB_PREFIX) and run

Code Select Expand

SELECT name
FROM prefix_product_descriptions
WHERE name LIKE '%( Copy )%';
but it is unsafe to delete only from product_descriptions, because products are linked across several tables.

thank you for support, actually they were very old products data and we already deleted them from website dashboard but on database still saved and i don't know why they stayed there if already deleted them from the panel. any way I did solved my issue but there is still a small issue. when the AI BOT retrieving the data about products from the database table we have n the product description section an html info and the AI BOT printing them in the answer section and still trying to find a solution for this too.

#34

Template Support / Re: database issue

Last post by Basara - May 21, 2026, 05:56:28 AM

Hello.
Products may also be missing from Admin if cache is outdated, or if the product is not assigned to the store view you are checking.

Those names are stored in the product description table. To check them in the database, use your own AbanteCart table prefix from system/config.php (DB_PREFIX) and run

Code Select Expand

SELECT name
FROM prefix_product_descriptions
WHERE name LIKE '%( Copy )%';
but it is unsafe to delete only from product_descriptions, because products are linked across several tables.

#35

Template Support / Re: database issue

Last post by G. O. - May 21, 2026, 12:56:24 AM

Hello.
In AbanteCart admin, search for "( Copy )", select all, and remove. Direct database edits are strongly discouraged.

the problem is not on admin side, there is nothing in products side panel, it is in the database. I'm getting this information when we are exporting products information from database information to website AI Assistant bot, bot retrieving these information from product id table

#36

Template Support / Re: database issue

Last post by Basara - May 20, 2026, 10:25:54 AM

Hello.
In AbanteCart admin, search for "( Copy )", select all, and remove. Direct database edits are strongly discouraged.

#37

Template Support / database issue

Last post by G. O. - May 20, 2026, 08:06:03 AM

Hello,

i need you help to know the best way to remove these duplication on database as you see in the bottom extracted text: how to remove these duplications from database? all of this came from cloning the products for fast edits of products details 📊 Found 356 duplicate/copy products

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
DUPLICATE PRODUCTS LIST:
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📦 ORIGINAL/CATEGORY: 01-171 ( Copy )
  └─ Duplicate: 01-171 ( Copy ) (ID: 2103)
  └─ Duplicate: 01-171 ( Copy ) (ID: 2103)
  └─ Duplicate: 01-171 ( Copy ) (ID: 2143)
  └─ Duplicate: 01-171 ( Copy ) (ID: 2143)
  Total copies: 4


📦 ORIGINAL/CATEGORY: 01-171 ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy )
  └─ Duplicate: 01-171 ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) (ID: 2110)
  └─ Duplicate: 01-171 ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) (ID: 2110)
  └─ Duplicate: 01-171 ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) (ID: 2149)
  └─ Duplicate: 01-171 ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) ( Copy ) (ID: 2149)
  Total copies: 4



they are 📊 Found 356 duplicate/copy products and this is just a sample of what i have in the database

#38

Tips and Tricks / Re: AI and AbanteCart

Last post by Wang Evelyn - May 20, 2026, 06:09:52 AM

I've been experimenting with AI tools for smaller AbanteCart customizations and they're surprisingly useful for speeding up template edits, SQL queries, and extension debugging. The biggest benefit for me is explaining unfamiliar parts of the codebase quickly instead of digging through files manually.

Still important to review everything carefully though, especially for payment logic or checkout modifications. AI saves time, but it can definitely generate code that looks correct while breaking existing functionality.

#39

Extension Support / Re: [Possible Bug + Fixes] Pay...

Last post by Basara - May 20, 2026, 02:46:19 AM

Hi RCodiaDavid,

Thanks for taking the time to write this up and share the fixes you tried.

Before we can say much about the cause, we need a few more details about the actual PayPal transactions. PayPal Commerce can route payments through different methods depending on the customer and country, so this may not be the same path for every order.

Can you please check one of the affected payments and let us know:
1. what country the customer was from
2. the order currency
3. (important!) which payment method was actually used in PayPal, for example Sofort, Venmo, Pay Later, EPS, SEPA, Bancontact, card, PayPal balance, etc.
4. whether Product Page Checkout Buttons and Cart Page Checkout Buttons are enabled in your PayPal Commerce settings or you are sure the customer went through the normal full checkout flow
5. whether the cart had products requiring shipping, digital products, or both

The payment method is especially important because, depending on the method, the customer may even be asked to scan a QR code and complete the payment on their phone, so it is crucial to know which payment method was used.

The payment method can be visible in the PayPal transaction details. You can also check the logs in your PayPal developer account at developer.paypal.com to see if there are related API or webhook records for those transactions.

Once we know these details, it will be much easier to reproduce or narrow down where the checkout flow is breaking.

#40

Extension Support / Re: Possible bug in USPS exten...

Last post by Heemet - May 19, 2026, 06:05:53 PM

Hello Basura,

Thank you for your reply.  Regarding USPS media mail, are we able to configure a product in AbanteCart to flag it as eligible for USPS media mail, so that a user can select it as a shipping option?  I don't see a setting on the configuration page for a product to identify it as eligible for media mail. 

Thank you!