Go Premium for a chance to win a PS4. Enter to Win

x

Magento

213

Solutions

289

Contributors

Magento is an open-source e-commerce platform written in PHP for e-commerce web sites. Magento employs the MySQL/MariaDB relational database management system, the PHP programming language, and elements of the Zend Framework. It applies the conventions of object-oriented programming and model–view–controller architecture. Magento also uses the entity–attribute–value model to store data.

Share tech news, updates, or what's on your mind.

Sign up to Post

I have the following mysql query which find duplicate urls in Magento 1. I would like to run an update query which will add a unique value onto the end of any duplicate urls ('value' in the query), probably just -1, -2, -3 etc for each duplicate it finds.

Could someone advise on how to do?

SELECT COUNT(DISTINCT entity_id) AS amount, `value`, entity_id FROM catalog_product_entity_varchar v WHERE EXISTS ( SELECT * FROM eav_attribute a WHERE attribute_code = "url_key" AND v.attribute_id = a.attribute_id AND EXISTS ( SELECT * FROM eav_entity_type e WHERE entity_type_code = "catalog_product" AND a.entity_type_id = e.entity_type_id ) ) GROUP BY v.VALUE HAVING `amount` > 1 ORDER BY `amount` DESC

Open in new window

0
Keep up with what's happening at Experts Exchange!
LVL 11
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Hi Experts

Could you explain if PHP Magento use is always interactive?

After a quick view over its features - even it has an MVC architecture, the configurations looks to be only by use of interactive menus.
Any programation is needed, so? or optionally it could be done?

Thanks in advance.
0
I need a responsive theme for the now unsupported Magento Professional ver. 1.10.0.2.

There are many themes out there but I can't find anything that says it supports Magento ver. 1.10.0.2.  Ideally, I'd like something that is free.

If this does not exist, is there a reasonably easy way to adapt other designs to 1.10?
0
I have installed oodo 10 in ubuntu operating sytem.

i want to  install magento connector module in oodo 10.

 i have added it oodo addons folder and restart oodo server.

But module not showing under apps section in oodo administrator section.

1. I found one solution -
  i. if admin have "Technical Feature" permisssion then admin able to install module from oodo administrator section. but there is no Technical Feature option in administrator details of my oodo admin section.

  ii. i have also activated developer mode but "Technical Feature" option not showing in administrator details of my oodo admin section.

So Please help me how to install oodo module

Please help me how to install magento connector module in oodo 10
0
Hi

I have a friend who is asking for a client :) about their Magento site.  They currently are using Magento 1.14.3.4  Enterprise.

They have a few questions.

1)  Is 1.14.3.4 the most current version of Magento Enterprise?
2)  When is the "end of life"for this version of Magento Enterprise.
3)  Is Magento 2 what they will need to upgrade to?   Or are there other Magento Enterprise options?

Thanks!

Rowby
0
I'm doing a B2B site where customers frequently go in and out of 'on hold', and the doddery old accounts staff are not really up to clearing the cache, is there a quick way to update an attribute and clear the cache  only for that attribute change in one go?
0
Hello,

I am on magento and having an issue where the query string is getting stripped.

We had the server running http and decided to move it to https, when we did that the query strings are getting truncated when it redirects.

I tried lots of variations but none worked, most broke the website with too many redirects.

Currently:
http://www.domain.com/?test=1
redirects to
https://www.domain.com

https://domain.com/?test=1
redirects to
https://www.domain.com/?test=1

domain.com/?test=1
redirects to
https://www.domain.com

centos7 server

I am not using any htaccess redirects at this moment, they are all being redirected through the index at the moment.

I am not sure why this is so hard to accomplish for me, I would love any help.

Matt
0
I have inherited a site that is WP and Magento integrated. I have verified that they are using the same database. I have also verified the wordpress site URL and blog URL are pointing to the WP installation inside PUBLIC_HTML/WP (magento installation).

When I log into magento and browse to the section for WordPress > WP Admin, I am prompted with the username and password of the wordpress admin user. When I enter them and press enter, I get the following error
There was an error logging you into WordPress. Please check your WordPress Admin credentials below and try again

Open in new window


I am able to browse to the wordpress admin page (/WP-admin) and log in with the credentials that give the the above error. So it appears to me that wordpress is ok with this username / password but magento is not.

I do not see any plugins in the wordpress dashboard for Magento.

Please help experts = )
0
When upgrading Magento, is it possible to install 2.4 directly to 1.9.3, or does each upgrade have to be done in sequence? (1.9.4 > 1.9.5 > 2.0 > 2.1 >2.2 >2.3 then 2.4)
0
I inherited a site that is WordPress and Magento integrated. This will be my first time with Magento. Backed up the wordpress database, but I don't see any "mg" tables in the DB.

When companies setup a WP to Magento integration, do they often keep WP and Magento data in separate DBs?
0
Free Tool: Port Scanner
LVL 11
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I just inherited a megento site that is integrated with WordPress. I am trying to figure out how to remove a section from the main horizontal nav bar (See attached).

I logged into magento and I can see menu options under CATALOG > MANAGE CATEGORIES for everything except blog.

Not sure why they integrated with WP, but I can't seem to edit the menu in WP and I can't find in Magenot where to remove the "BLOG" part of the menu.
how-to-remove-BLOG-from-magento-nav-.pdf
0
Here is my question with supporting screenshots (let me know if you think I’ve overlooked anything obvious):


We have a Magento 2 multisite setup, with categories set up like so

Site categories
Our issue is that when editing some (but not all) of these categories, in different store views, Magento throws the following error and does not save the data:

Error message
In this case, the name of the “Supplements” category was edited in the Chinese store view.  It shows the changed value of the name in this view but refreshing the page show that it is not saved at all.

Editing the same category in the default store view does not result in the same issue

Ensuring that the “Default” checkbox is unchecked for the url key field in the Chinese store view makes no difference

URL Key (store view)

We have tried removing url rewrites for this category (based on the error message and other posts we have reviewed) but this does not help.

We are running M2 Community 2.1.5.

Traced the issue back to a db save error in the url rewrite table:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '90-3' for key 'URL_REWRITE_REQUEST_PATH_STORE_ID', query was: INSERT INTO `url_rewrite` (`redirect_type`,`is_autogenerated`,`metadata`,`description`,`store_id`,`entity_type`,`entity_id`,`request_path`,`target_path`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?,

Open in new window

0
can some body point me to  any  API documentation that could be generated using Swagger
0
I'm new to PHP and I'm working with the monster Magento, in my shared ISP environment my header 'Authorization' (used for REST) is getting stripped and being put into $_SERVER['REDIRECT_HTTP_AUTHORIZATION'].
Is there a way to inject the $_SERVER['REDIRECT_HTTP_AUTHORIZATION'] into the headers as 'Authorization:xxxx' ?
0
Hello,

How can it be done that Magento uses a different theme for Pc and mobile device?

Thank you very much.
0
I am getting this error on service apache2 restart

Error: SSLCertificateFile: file '/etc/apache2/ssl/www_example_com.crt' does not exist or is empty

i am trying to configure comodo ssl certificate on ubuntu ec2 instance with lamp and i have performed all official steps by following below links.

https://help.ubuntu.com/community/ApacheMySQLPHP https://help.ubuntu.com/14.04/serverguide/httpd.html#https-configuration

please help...,
0
Hello Experts,

Is there anyway I can add bootstrap to my magento2  store so I can have a good looking ecommerce website?

Thanks
0
I want to remove the decimal in price both in Front End and Admin Panel.

Is there something like an ET Currency Manager extension for Magento 2.1.3 (because that extension is only compatible up to 1.9.3) or other ways to remove it?
0
Hello,
I do have magento 2 with default Luma theme, how can I hide quantity (product page, cart and summary page in checkout)

E.g. http://www.nasstaging.com/mohinish/meet-assist-arrival-kuwait-international-airport.html

regards,
Kettaneh
0
How to Use the Help Bell
LVL 11
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

I want to remove the decimal in the standard number of the bundle product I created in Magento 1.9.3

Capture.PNG
This is the inventory config of this bundle product.

Capture.PNG
In simple products, there is a field qty uses decimals set to no. But there is none in Bundle products.


In the backend, the template has this value of it's textbox:
value= "{{selection_qty}}"

Open in new window


I tried the round and number format in this value but it didn't work because {{selection_qty}} is not a php code.

How can I remove the decimals?
0
I have a database in amazaon web service. I connect it with mysql Workbench. In another server I have a website(magento).
Now how can I connect the database with magento website as the database and website is in different server.
0
I am at a loss in not finding this info.
Assuming all the transactional emails go out on a cron job, but they are coming from different departments - sales/shipping etc, so different email accounts so different smtp credentials, but I can't see where to enter them in?
In the 'Store Email Addresses' config section, it just has 'Sender Name' and 'Sender Email', but no password field.
If I leave that blank surely the mail server is going to be vulnerable?
0
Hello, I was working on a website and accidentally got rid of a comma and text in the visual content. It made the slider go from 980x335 to 980x20. So the slider shows but is only 20 pixels long. I have the code in magento but I can't see that there is a static block associated with the slider. I have attached what the code looks like on the content of the page.
ispiritualhomepage.txt
0
Hello,
I'm attempting to add a new form element to a checkout page and have followed instructions from the following guide: http://devdocs.magento.com/guides/v2.0/howdoi/checkout/checkout_new_step.html

However the static javascript file is not being generated.

The error message for the missing file is

"Unable to resolve the source file for ...heard.js"
The file structure is:

Namespace/Module/view/frontend/layout/checkout_index_index.xml
Namespace/Module/view/frontend/web/js/view/heard.js
Namespace/Module/view/frontend/web/template/heard.html
The value in checkout_index_index.xml is Namespace_Module/js/view/heard

The module is showing in the list of installed modules and I've recompiled the source and the Magento version is 2.1.2
0
I was moving some blocks of code to re-arrange the order and it was working fine until my last edit.  Now I'm not sure what happened.  Please look at the attached home page code and see if there is something wrong.  There is supposed to be a product slider below the image in it's own block.

The website is www.ispiritual.com
homepage.txt
0

Magento

213

Solutions

289

Contributors

Magento is an open-source e-commerce platform written in PHP for e-commerce web sites. Magento employs the MySQL/MariaDB relational database management system, the PHP programming language, and elements of the Zend Framework. It applies the conventions of object-oriented programming and model–view–controller architecture. Magento also uses the entity–attribute–value model to store data.

Top Experts In
Magento
<
Monthly
>