Archive for the ‘Database’ Category

Change Magento Order Customer Association

magento button Change Magento Order Customer AssociationEver have a customer contact you because they forgot to place their order with their registered profile?  Well I have.  Alot.

And Magento doesn’t have an “out of the box” way to modify the order to customer profile relationship even though the solution is really simple.

Simple that is, if you are comfortable writing queries in the database.

(more…)

Thursday, November 3rd, 2011

Change Magento Order Email

magento button Change Magento Order EmailSometimes a customer will input a typo when entering their email address in Magento.  If they do this they won’t get their email notifying them of the order.  (if you have this setup.) And other things may not happen as expected and or desired.

Out of the box, the Magento admin does not have the ability to change this.  But if you are comfortable in the database, then these steps will let you make this change in seconds.

(more…)

Thursday, October 27th, 2011

What is a Database

Definition:  A database is a structured collection of records or data.

Many moons ago, I was shown an database that was constructed back in the 50s.  It was hand held and consisted of a stack of cards that contained information about plant biology.  There was a series of holes that wrapped around the cards, some of the holes were notches, and others were not.

To query the database, one placed a pin through one of the wholes and let the cards that had a notch fall out of the stack.  You could continue this process by removing and adding pins to select different combination of data.

Once you had narrowed your search, you could read the cards, and retrieve the data.

This was a very manual process, and I doubt that anyone today would take the time to learn to use such a tool, let alone update or add records to it. (more…)

Wednesday, September 7th, 2011

Mapping Excersizes: EDI Invoice to Open Office Tables (part One)

math Mapping Excersizes: EDI Invoice to Open Office Tables (part One)This is a mapping exercise that will go through the process of creating a paper map, or mapping document.  We will start with an empty paper map that you can get here.  And we will end with a completed paper map document that documents what data from the source goes into what fields on the target.  This process will take more than one post, and I will link them together so that you can follow from one to the next.  Along the way, we will discuss the things that we are doing so that you can apply this technique in your mapping using the target and source in your own mapping tasks. (more…)

Thursday, February 3rd, 2011

5 Tools of an Integration Engineer

tool pile puzzlepiece1 5 Tools of an Integration EngineerThere are job or task specific tools that will have a high importance to each integration task.  When working on an SAP system, your SAP tools will be very important.  But there are tools and skills that are also important regardless of the systems and technologies that you are working on.  For me, these are the top 5 tools that an Integration Engineer should be able to use proficiently.  Do you use any of these?  Do you have others? (more…)

Wednesday, January 19th, 2011

  • Sign up for our FREE Newsletter

  • Catagories


  • Affiliate Ads

Powered by WP Robot