memel

Could you please provide us with detailed information on this matter in the Help Desk?

 

Thank you.

Ticket ID: #103546756

Regards

Addon PayPal Commerce not working with PHP8.0. When you trying to open orders, brakes the page. 

Is any documentation for new addon Import from Shopify?

Thanks

New upgrade not working, getting error:

<div class="message">
Sorry, service is temporarily unavailable.
</div>
</body>                 
</html><!--

Tygh\Exceptions\AException

Message
Unknown column 'descr1.page_title' in 'where clause' (1054)SELECT SQL_CALC_FOUND_ROWS products.product_id, companies.company as company_name, popularity.total as popularity, products.product_type, products.parent_product_id, descr1.product as product, descr1.short_description, descr1.full_description, IF(products.age_verification = 'Y', 'Y', IF(cs_categories.age_verification = 'Y', 'Y', cs_categories.parent_age_verification)) as need_age_verification, IF(products.age_limit > cs_categories.age_limit, IF(products.age_limit > cs_categories.parent_age_limit, products.age_limit, cs_categories.parent_age_limit), IF(cs_categories.age_limit > cs_categories.parent_age_limit, cs_categories.age_limit, cs_categories.parent_age_limit)) as age_limit, 1 as instock_marker, 
            IF(
                products.product_type = 'C',
                (SELECT MAX(amount) FROM cs_products WHERE parent_product_id = products.product_id) > 0, 
                IF(
                    products.amount > 0,
                 1, 
                 IF(
                    products.tracking = 'O', 
                    1, 
                    0
                 )
                )
            ) as instock_sorting, products.currency, products.amount, products.purchase_qty, companies.vendor_in_vacation as vendor_in_vacation, companies.no_hide_product_vacation as no_hide_product_vacation, companies.no_hide_product_not_working_hours as no_hide_product_not_working_hours, companies.timezone_vacation as timezone_vacation, companies.working_hours_from as working_hours_from, companies.working_hours_to as working_hours_to FROM cs_products as products  LEFT JOIN cs_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cs_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cs_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cs_categories ON cs_categories.category_id = products_categories.category_id  AND (cs_categories.usergroup_ids = '' OR FIND_IN_SET(0, cs_categories.usergroup_ids) OR FIND_IN_SET(2, cs_categories.usergroup_ids) OR FIND_IN_SET(1, cs_categories.usergroup_ids)) AND cs_categories.status IN ('A', 'H') AND cs_categories.storefront_id IN (0, 1)  LEFT JOIN cs_product_popularity as popularity ON popularity.product_id = products.product_id INNER JOIN (SELECT *, product_id as prod_id FROM cs_cp_search_cache_en) as descr1 ON products.product_id = descr1.prod_id LEFT JOIN cs_products_categories ON cs_products_categories.product_id = descr1.product_id LEFT JOIN cs_tag_links as cp_tg_l ON cp_tg_l.object_id = products.product_id AND cp_tg_l.object_type = 'P' LEFT JOIN cs_tags as cp_rg ON cp_tg_l.tag_id = cp_rg.tag_id  AND cp_rg.status = 'A' WHERE 1  AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(2, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 2, 1) AND products.parent_product_id = 0 AND ((descr1.search_words LIKE '%bedding%') OR (descr1.product LIKE '%bedding%') OR (descr1.meta_keywords LIKE '%bedding%') OR (descr1.meta_description LIKE '%bedding%') OR (descr1.page_title LIKE '%bedding%') OR (descr1.features LIKE '%bedding%') OR (descr1.options LIKE '%bedding%') OR (descr1.product_code LIKE '%bedding%') OR (descr1.product_code_combinations LIKE '%bedding%') OR (companies.company LIKE '%bedding%') OR cs_products_categories.category_id IN (67, 68, 68, 67, 413, 413, 473, 473, 414, 414, 471, 471, 472, 472, 1509, 1509, 1513, 1516, 1519, 1510, 1510, 1514, 1517, 1520, 1511, 1511, 1515, 1518, 1521, 1512, 1512, 1522, 1523, 1524, 66, 68, 68, 67, 413, 413, 473, 473, 414, 414, 471, 471, 472, 472, 1509, 1509, 1513, 1516, 1519, 1510, 1510, 1514, 1517, 1520, 1511, 1511, 1515, 1518, 1521, 1512, 1512, 1522, 1523, 1524)) AND NOT FIND_IN_SET('bedding', descr1.stop_words) AND companies.company_id IN (13, 14, 209, 254, 257) AND products.product_type != 'D' GROUP BY products.product_id   ORDER BY instock_sorting DESC, popularity.total desc, products.product_id ASC  LIMIT 0, 25

Error at
app/Tygh/Database/Connection.php, line: 1540

Backtrace
File:app/Tygh/Database/Connection.php
Line:690
Function:throwError

File:app/Tygh/Database/Connection.php
Line:307
Function:query

File:app/functions/fn.database.php
Line:35
Function:getArray

File:app/functions/fn.products.php
Line:2271
Function:db_get_array

File:app/functions/fn.products.php
Line:2354
Function:{closure}

File:app/addons/cp_live_search/controllers/frontend/products.pre.php
Line:331
Function:fn_get_products

File:app/functions/fn.control.php
Line:722
Function:include

File:app/functions/fn.control.php
Line:458
Function:fn_run_controller

File:index.php
Line:25
Function:fn_dispatch


-->

One of the potential improvements we hope to see for the "Vendor Business Hours" add-on would be the ability to set different hours by day of week.  As an example:

• Monday         9am -  5pm  (normal business hours)
• Tuesday        9am -  5pm  (normal business hours)
• Wednesday   9am -  5pm  (normal business hours)
• Thursday       9am -  9pm  (open late for busy workers)
• Friday            9am -  7pm  (late closing)
• Saturday       10am -  7pm  (late open, late closing)
• Sunday          Closed

The "Vacation Days setting is convenient for 1-person and 2-person stores when nobody will be available to work, and that's great.  For larger stores, it is less likely that everybody will be on vacation, but this feature is convenient for designating "Closed for Holiday" with different designated holiday store closing throughout the year.

 

It might also be nice to have hours designated for shipping (orders received after 3pm will be shipped the following day) or delivery (local delivery orders will be processed between 9am - 6pm).  

 

This is a great add-on.  These additional features will really empower Multi-Vendor to accommodate the needs of their vendors and shoppers!

Look at my post above from 2019. Never happened!

Good luck!