Magento 2.0 admin / Marketing job in Asheville, NC

I apologize! I know this position will be “beneath” most of the people on this board, but I’m hoping there might be a couple of recent grads or that someone may know a recent grad who might be good for this open position. This is an “early career” position in Asheville, NC with the Marketing Department of a large eCommerce company. The roles is basically 70% Magento administration 30% general marketing. The Magento portion would mostly be content updates but would also include some light customization, page creation, etc. The marketing portion would be digital marketing heavy in paid advertisements (PPC, SEM, etc), email campaigns, social media marketing, SEO, etc.

The position would be great for someone with an internship or just a couple of years of professional working experience looking to dive in deep with a large marketing department and a lot of people to learn from. Compensation is probably in the $40-50k range, maybe up to $60k for the right person.

No sponsorship provided. Not open to contractors or consultants. FTE, direct-hire only. Sorry, but no relocation assistance is provided either. If you would like to apply please send an email to [[email protected]](mailto:[email protected]).

submitted by /u/Otracosamariposa
[link] [comments]

Direct SQL query to transfer Magento 1.x customer data via CSV into Magento 2

Basicly see the title.

Googled to transfer customer data (address and passwords too) from magento 1.x into Magento 2, without using the migrate tool. Just a direct DB output into a CSV to be able to upload it into Magento 2.

But found only plugins which cost around $70. But I’m cheap so I build it myself and if anyone wants to use it in the future he/she has it now too:

SELECT "email", "_website", "_store", "confirmation", "created_at", "created_in", "disable_auto_group_change", "dob", "firstname", "gender", "group_id", "lastname", "middlename", "password_hash", "prefix", "rp_token", "rp_token_created_at", "store_id", "suffix", "taxvat", "website_id", "password", "_address_city", "_address_company", "_address_country_id", "_address_fax", "_address_firstname", "_address_lastname", "_address_middlename", "_address_postcode", "_address_prefix", "_address_region", "_address_street", "_address_suffix", "_address_telephone", "_address_vat_id", "_address_default_billing_", "_address_default_shipping_" UNION ALL select email, "base", "admin", "", a.created_at, l.value, "", "", m.value, "", group_id, n.value, "", concat(o.value,":0"), "", "", "", store_id, "", "", website_id, "", c.value, "", d.value, "", e.value, f.value, "", g.value, "", if(h.value is NULL,"",h.value), i.value, "", j.value, "", 1, 1 from customer_entity a join customer_address_entity b on a.entity_id=b.parent_id left join customer_address_entity_varchar c on b.entity_id=c.entity_id and c.attribute_id=26 left join customer_address_entity_varchar d on b.entity_id=d.entity_id and d.attribute_id=27 left join customer_address_entity_varchar e on b.entity_id=e.entity_id and e.attribute_id=20 left join customer_address_entity_varchar f on b.entity_id=f.entity_id and f.attribute_id=22 left join customer_address_entity_varchar g on b.entity_id=g.entity_id and g.attribute_id=30 left join customer_address_entity_varchar h on b.entity_id=h.entity_id and h.attribute_id=28 left join customer_address_entity_text i on b.entity_id=i.entity_id and i.attribute_id=25 left join customer_address_entity_varchar j on b.entity_id=j.entity_id and j.attribute_id=31 left join customer_address_entity_int k on b.entity_id=k.entity_id and k.attribute_id=29 left join customer_entity_varchar l on a.entity_id=l.entity_id and l.attribute_id=3 left join customer_entity_varchar m on a.entity_id=m.entity_id and m.attribute_id=5 left join customer_entity_varchar n on a.entity_id=n.entity_id and n.attribute_id=7 left join customer_entity_varchar o on a.entity_id=o.entity_id and o.attribute_id=12 INTO OUTFILE '/tmp/customers_combined.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n'; 

Hope you can live with no comments, if one needs other fields to which I left blank (“”) here, they are most likely in one of those customer_address_entity_*/customer_entity_* tables where you have to lookup up the attribute_id and add it to the query.

submitted by /u/JealousEntrepreneur
[link] [comments]

Finally – Magento Development Made Easy

If you aren’t a licensed partner to get access to official Magento training, learning Magento is like feeling your way around the dark. You have to Google all day long and more often than not there are two or three ways to do something – which one is best?!

What if you could get a module that:

  • Has beautiful and easy-to-access documentation showing you exactly how to do what you need.
  • Cut your development for new modules in half because you don’t have to figure out which classes to inject, objects to instantiate or repos to access?
  • Was built to use the latest Magento standards, future-proofing your own work? No going back and fixing stuff after a new version release!
  • Helps you to quickly on-board new Magento developers to your team because all the answers they have is answered in the module’s documentation (how do I get a product by SKU, how do I get the current store ID, how do I custom attributes etc.)

I’ve started the basic outline for such a module and would love to hear if you would be as interested in this as I am? Let me know in the comments below.

TLDR; would you be interested in a Magento module that answers all the “how do I…” questions you have about Magento? It does all the heavy lifting in the backend and you only have to call one-liners to do everything you now manually have to figure out on a day-by-day basis.

submitted by /u/KBeer01
[link] [comments]

Not sure where to start. Tips?

I inherited a project that is using the enterprise edition of Magento 2. I have managed to get the project up and running, and now I’m trying to wrap my head around all this.

I come from a Drupal background, where modules extend core functionality, and there’s a theme layer that is generated on the fly. If I am understanding correctly, you have to run a command to “deploy” the code to another directory in your Magento install?

Needless to say, it’s all quite new and I’m needing to get things like the enterprise edition updated to the latest release, and update the modules/extentions/whatever they’re called ASAP.

What’s the best place to start digging in? With the different versions of Magento, and being pretty new to this, I’m a little overwhelmed. But, it seems like the community is pretty nice, and I like that lot.

submitted by /u/a_total_throwaway_
[link] [comments]

The best mega menu extension for Magento 2 developed with best practices

I am compiling a list of best Mega Menu extensions for Magento 2, ofcourse developed with the best practices.

Can you please comment on the one that you want to recommend?

I have checked a few demos(frontend and backend) and found two of the below bit better:

submitted by /u/MagePsycho
[link] [comments]