Messages

Hello Basara,

If you ship via PayPal, the USPS rates are commercial rates.  However, the default USPS extension in AbanteCart returns retail rates, which are higher.  Thus, if a customer checks-out and selects a USPS shipping option, he will be overcharged at the retail rate.

It appears that the USPS API allows for the API call to request commercial rates.  See here:
https://github.com/USPS/api-examples

The field is "priceType": "COMMERCIAL"

It seems that this would be an easy change in the USPS extension in AbanteCart, but I can't figure out where to set this field.

Thanks,
Peter

please change manually file (via cPanel filemanager)
public_html/extensions/usps/storefront/model/extension/usps.php

See lines 514 and 545.

Please let us know about result.

hi,
the easiest way is a auto-forwarding on your store main mailbox.

please test this solution.
https://github.com/abantecart/abantecart-src/commit/d8e4737bbdafadb49b94521bd49c3cdb6cc980d0

you can replace your file with new

what version of abantecart do you use?
I remember we added more clear message for such case in the 1.4.0

Hi,
please read this topic https://forum.abantecart.com/index.php/topic,11249.0.html

Shortly, you should to create two indexes before upgrade process.

please try this fix and let us know

https://github.com/abantecart/abantecart-src/commit/14872852c907429920291d8e7630fb43e2d80bb5

Looks like you ran upgrade.sql twice.

If you do not have a database backup of 1.4.2, you can rollback database structure manually.

See https://github.com/abantecart/abantecart-src/blob/master/public_html/install/abantecart_database_upgrade.sql for details

it's just a warning.
Please check table data via phpMyAdmin.
Open table "pages" and find rows with controller "pages/product/category"
You will see another columns "key_param" and "key_value".
Please check if some data presents in "key_param" but "key_value" is empty.

To fix warning you should be sure that both columns are filled or empty.

To solve this issue run this sql in your phpMyAdmin.
Do not forget replace table prefix `ac_ with your's before run.

Code Select Expand

alter table `ac_ant_messages`
    modify `start_date` timestamp null;

alter table `ac_ant_messages`
    modify `viewed_date` timestamp null;

alter table `ac_banner_descriptions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_banners`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_block_descriptions`
    modify `date_added` timestamp default current_timestamp() not null;

alter table `ac_block_descriptions`
    modify `date_modified` timestamp default current_timestamp() not null on update current_timestamp();

alter table `ac_block_templates`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_blocks`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_categories`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_collections`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_content_descriptions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_contents`
    drop primary key,
    MODIFY COLUMN `content_id` INT AUTO_INCREMENT PRIMARY KEY;

alter table `ac_coupons`
    modify `date_start` date null;

alter table `ac_coupons`
    modify `date_end` date null;

alter table `ac_coupons`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_coupons_categories`
    charset = utf8mb4;

alter table `ac_custom_blocks`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_custom_lists`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_customer_notifications`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_customer_transactions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_customers`
    modify `telephone` varchar(32) default '' not null,
    modify `date_added` timestamp default current_timestamp() null,
    modify `last_login` timestamp null;
update `ac_customers` SET `date_added` = `date_modified` WHERE `date_added` = '0000-00-00 00:00:00';

alter table `ac_downloads`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_email_templates`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_extensions`
    modify `date_installed` timestamp null;

alter table `ac_extensions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_global_attributes_type_descriptions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_language_definitions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_layouts`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_length_classes`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_locations`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_messages`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_online_customers`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_order_data`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_order_data_types`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_order_downloads`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_order_history`
    modify `date_added` timestamp default current_timestamp() null;

ALTER TABLE `ac_orders` MODIFY date_added timestamp default current_timestamp();
update `ac_orders` SET date_added = date_modified WHERE date_added = '0000-00-00 00:00:00';

alter table `ac_page_descriptions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_pages`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_product_discounts`
    modify `date_start` date null;

alter table `ac_product_discounts`
    modify `date_end` date null;

alter table `ac_product_discounts`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_product_specials`
    modify `date_start` date null;

alter table `ac_product_specials`
    modify `date_end` date null;

alter table `ac_product_specials`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_products`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_resource_descriptions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_resource_library`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_resource_map`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_reviews`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_settings`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_task_details`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_task_steps`
    modify `last_time_run` timestamp null;

alter table `ac_task_steps`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_task_steps`
    engine = InnoDB;

alter table `ac_tasks`
    modify `last_time_run` timestamp null;

alter table `ac_tasks`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_tax_classes`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_tax_rates`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_user_groups`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_user_notifications`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_users`
    modify `last_login` datetime null;

alter table `ac_users`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_weight_classes`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_zones_to_locations`
    modify `date_added` timestamp default current_timestamp() null;

try this

Code Select Expand

<div class="col-md-5 col-xl-12 text-center text-white ">
    <h1 class="ms-4 text-white">Custom Metal Work</h1>
    <p class="mb-4">Shop our collection of Metal signs and decor</p>
    <a href="#" class="btn btn-outline-light">Shop Now</a>
</div>
For more information see standard bootstrap css-classes here

hi, error code 400 usually set in case code is "unknown". 
Please provide more details how we can replicate this bug locally.
We need to know
host, OS, php version, url which returns 400 and precise settings of your cart. 
Screencast video and screenshots will be useful.

hi,
what about install/upgrade log?

Hi

I believe this has been asked before but was 9 years ago under a totally different release.  So I cannot seem to find the comparison files that were apparently java files.

I'd like to be able to adjust the image speed for the next image in the slider.

So if a product is viewed and there are 5 images for example, its a bit too slow for my liking so wondered if we can adjust this. Its currently about 5 seconds.

Unless I haven't see it in the configuration....

1. go to admin->design->layout->choose Home page layout
2. Click gear button of block you should to change.
if block based on bootstrap5 carousel component:
- In the html-Editor find all divs with class "carousel-item" and add new html-attribute data-bs-interval="1000". See more details here https://getbootstrap.com/docs/5.3/components/carousel/#individual-carousel-item-interval
- For "owl" based sliders you should to edit template of it. See wrapper selector on the block edit form.
For example: public_html/extensions/novator/storefront/view/novator/template/blocks/listing_block/popular_brands_content_bottom.tpl

please replace two files with attached

public_html/admin/controller/responses/sale/invoice.php
and
public_html/admin/view/default/template/responses/sale/order_invoice.tpl

Looks like you had ran upgrade twice.
Your database structure now under v1.4.2, but php code is 1.4.1.
Just restore database from backup and run upgrade again