How do I add product data and directly to the database, which tables need to be updated in what order?Magento 2: Diagram of database tables, such as Orders, Products, etc. and their relationshipsWhat are the main tables that updated when we creating new product in magento?How to completely delete EAV attribute and all its data from the database?Magento 2: Diagram of database tables, such as Orders, Products, etc. and their relationshipsHow can I truncate the tax class tables and not break my install?Magento 2: What is the difference between the row_id and entity_id in the %_entity tables?How are values for bundle product stored in the database?Magento2 - How to Export mysql database without products,orders and customers data?What are cons to accessing magento database directly to pull out product dataHow to sync database between local or staging and the live storeMagento 2 Custom API: Need to create an API which gets the data from a table in databaseHow to restore only the product data sheet
Can one block with a protection from color creature?
This LM317 diagram doesn't make any sense to me
As a supervisor, what feedback would you expect from a PhD who quits?
Can a USB hub be used to access a drive from two devices?
QR codes, do people use them?
Jimmy needs your help!
What does "spinning upon the shoals" mean?
How should I ask for a "pint" in countries that use metric?
Is it ok for parents to kiss and romance with each other while their 2- to 8-year-old child watches?
Use ContourPlot data in ParametricPlot
Possibility to correct pitch from digital versions of records with the hole not centered
Sense of humor in your sci-fi stories
Why did Robert F. Kennedy loathe Lyndon B. Johnson?
What is the average number of draws it takes before you can not draw any more cards from the Deck of Many Things?
How do I explain that I don't want to maintain old projects?
Can you create a free-floating MASYU puzzle?
Users forgotting to regenerate PDF before sending it
Can a wizard use the spell Levitate on a target and shoot him with attacking spells that don't require concentration?
What is the highest level of accuracy in motion control a Victorian society could achieve?
Define functions in a tikzcd diagram
Who goes first? Person disembarking bus or the bicycle?
Quotients of a ring of integers
Attach a visible light telescope to the outside of the ISS
How can I review my manager, who is fine?
How do I add product data and directly to the database, which tables need to be updated in what order?
Magento 2: Diagram of database tables, such as Orders, Products, etc. and their relationshipsWhat are the main tables that updated when we creating new product in magento?How to completely delete EAV attribute and all its data from the database?Magento 2: Diagram of database tables, such as Orders, Products, etc. and their relationshipsHow can I truncate the tax class tables and not break my install?Magento 2: What is the difference between the row_id and entity_id in the %_entity tables?How are values for bundle product stored in the database?Magento2 - How to Export mysql database without products,orders and customers data?What are cons to accessing magento database directly to pull out product dataHow to sync database between local or staging and the live storeMagento 2 Custom API: Need to create an API which gets the data from a table in databaseHow to restore only the product data sheet
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
TLDR: Migrating Opencart to Magento, currently have 300+sku's and 100k+ product pages. What is the best practice for storing complex product data and programmatically adding and maintaining it directly to the database? What tables need to be updated, in what order and how best should I structure the product data.
The Detail:
Hello everyone in Magento community.
I am new to Magento and I am hoping through this post, user can point me in the direction of the best reading resources to answer some of my broad questions. Also, any specifics on how to tackle the solution would be very much welcomed.
So to the business problem. I am currently running Version 1.5.5.1 of Opencart, with a store of probably around 150,000 products.
Simply put, I am happy with how the store is operating, but due to the version, I am forced with either migrating to later version of Opencart, moving to Magento or rewiring my old store to work with newer versions of PHP.
Here - I'm looking for advice on migrating to Magento and how best to approach it.
Currently, my store is uniquely set up, as the product database is maintained by the backend c# system I've written myself. This is because managing the volume of products I have is just not tenable in Opencart.
Of particular importance, is conceptually for every one product in my local system, it generates 100's if not 1000's of product variations that get loaded onto Opencart.
To explain further, let's take a simple analogy of Car headlamp bulb. My site would advertise as sell:
Headlamp Bulb Ford Focus St
Headlamp Bulb Ford Focus Hatchback (2011 - 2018)
Headlamp Bulb Ford Focus Hatchback (2005 - 2011)
Headlamp Bulb Ford Focus RS (2009 - 2010)
Headlamp Bulb Ford Focus Estate (2011 - 2018)
etc etc
So for each make, model, variation the bulb fits, there would be a logical product on my site with a unique URL. My site doesn't sell headlamp bulbs, but this is just for example purposes.
The single product on my C# backend has an array of all the appropriate models a part will fit, then generates all the data for a website by interacting directly with the Opencart database via SQL.
I am now looking at migrating this process to Magento. With this I have the following questions:
What is the best way to logically represent the products in Magento and still have the "Headlamp Bulb Ford Focus Hatchback (2005 - 2011)" breakdown in the product title. Is it to have 1000's of simple products or is there a better approach using titles combined with product attributes?
If I go with 1000's simple products route, what are the common performance pitfuls I should be aware of to work around? For example in Opencart, I restricted it calculating the number of products in a category, heavily customised the search function and introduced custom page caching and optimised all the table indices to support large numbers of products being searched.
What is the best way to add new products to programmatically? Opencart I was working directly with the data tables, this was fast and didn't tie up the server too long when making large changes.
How do I manage logical inventory? With Multiple products representing one inventory item? "The Bulb", what is the best approach.
I am going to be needing to migrate customer data and orders - but I want to see if the inventory system is up to scratch first for what I need.
I am happy with taking on this work, doing the reading and legwork, but if people are able to point me in direction of I wish I read this first or understood this first from there experience of working with Magento.
So far my research I've found:
TABLES that are updated when creating a product
What are the main tables that updated when we creating new product in magento?
Very useful Table Entity-Relationship diagram for Magento:
Magento 2: Diagram of database tables, such as Orders, Products, etc. and their relationships
Many thanks!
magento2 module database migration extension-attributes
asked Jun 28 at 10:28
Gregory William BryantGregory William Bryant
11 bronze badge
add a comment |
TLDR: Migrating Opencart to Magento, currently have 300+sku's and 100k+ product pages. What is the best practice for storing complex product data and programmatically adding and maintaining it directly to the database? What tables need to be updated, in what order and how best should I structure the product data.
The Detail:
Hello everyone in Magento community.
I am new to Magento and I am hoping through this post, user can point me in the direction of the best reading resources to answer some of my broad questions. Also, any specifics on how to tackle the solution would be very much welcomed.
So to the business problem. I am currently running Version 1.5.5.1 of Opencart, with a store of probably around 150,000 products.
Simply put, I am happy with how the store is operating, but due to the version, I am forced with either migrating to later version of Opencart, moving to Magento or rewiring my old store to work with newer versions of PHP.
Here - I'm looking for advice on migrating to Magento and how best to approach it.
Currently, my store is uniquely set up, as the product database is maintained by the backend c# system I've written myself. This is because managing the volume of products I have is just not tenable in Opencart.
Of particular importance, is conceptually for every one product in my local system, it generates 100's if not 1000's of product variations that get loaded onto Opencart.
To explain further, let's take a simple analogy of Car headlamp bulb. My site would advertise as sell:
Headlamp Bulb Ford Focus St
Headlamp Bulb Ford Focus Hatchback (2011 - 2018)
Headlamp Bulb Ford Focus Hatchback (2005 - 2011)
Headlamp Bulb Ford Focus RS (2009 - 2010)
Headlamp Bulb Ford Focus Estate (2011 - 2018)
etc etc
So for each make, model, variation the bulb fits, there would be a logical product on my site with a unique URL. My site doesn't sell headlamp bulbs, but this is just for example purposes.
The single product on my C# backend has an array of all the appropriate models a part will fit, then generates all the data for a website by interacting directly with the Opencart database via SQL.
I am now looking at migrating this process to Magento. With this I have the following questions:
What is the best way to logically represent the products in Magento and still have the "Headlamp Bulb Ford Focus Hatchback (2005 - 2011)" breakdown in the product title. Is it to have 1000's of simple products or is there a better approach using titles combined with product attributes?
If I go with 1000's simple products route, what are the common performance pitfuls I should be aware of to work around? For example in Opencart, I restricted it calculating the number of products in a category, heavily customised the search function and introduced custom page caching and optimised all the table indices to support large numbers of products being searched.
What is the best way to add new products to programmatically? Opencart I was working directly with the data tables, this was fast and didn't tie up the server too long when making large changes.
How do I manage logical inventory? With Multiple products representing one inventory item? "The Bulb", what is the best approach.
I am going to be needing to migrate customer data and orders - but I want to see if the inventory system is up to scratch first for what I need.
I am happy with taking on this work, doing the reading and legwork, but if people are able to point me in direction of I wish I read this first or understood this first from there experience of working with Magento.
So far my research I've found:
TABLES that are updated when creating a product
What are the main tables that updated when we creating new product in magento?
Very useful Table Entity-Relationship diagram for Magento:
Magento 2: Diagram of database tables, such as Orders, Products, etc. and their relationships
Many thanks!
magento2 module database migration extension-attributes
asked Jun 28 at 10:28
Gregory William BryantGregory William Bryant
11 bronze badge
add a comment |
TLDR: Migrating Opencart to Magento, currently have 300+sku's and 100k+ product pages. What is the best practice for storing complex product data and programmatically adding and maintaining it directly to the database? What tables need to be updated, in what order and how best should I structure the product data.
The Detail:
Hello everyone in Magento community.
I am new to Magento and I am hoping through this post, user can point me in the direction of the best reading resources to answer some of my broad questions. Also, any specifics on how to tackle the solution would be very much welcomed.
So to the business problem. I am currently running Version 1.5.5.1 of Opencart, with a store of probably around 150,000 products.
Simply put, I am happy with how the store is operating, but due to the version, I am forced with either migrating to later version of Opencart, moving to Magento or rewiring my old store to work with newer versions of PHP.
Here - I'm looking for advice on migrating to Magento and how best to approach it.
Currently, my store is uniquely set up, as the product database is maintained by the backend c# system I've written myself. This is because managing the volume of products I have is just not tenable in Opencart.
Of particular importance, is conceptually for every one product in my local system, it generates 100's if not 1000's of product variations that get loaded onto Opencart.
To explain further, let's take a simple analogy of Car headlamp bulb. My site would advertise as sell:
Headlamp Bulb Ford Focus St
Headlamp Bulb Ford Focus Hatchback (2011 - 2018)
Headlamp Bulb Ford Focus Hatchback (2005 - 2011)
Headlamp Bulb Ford Focus RS (2009 - 2010)
Headlamp Bulb Ford Focus Estate (2011 - 2018)
etc etc
So for each make, model, variation the bulb fits, there would be a logical product on my site with a unique URL. My site doesn't sell headlamp bulbs, but this is just for example purposes.
The single product on my C# backend has an array of all the appropriate models a part will fit, then generates all the data for a website by interacting directly with the Opencart database via SQL.
I am now looking at migrating this process to Magento. With this I have the following questions:
What is the best way to logically represent the products in Magento and still have the "Headlamp Bulb Ford Focus Hatchback (2005 - 2011)" breakdown in the product title. Is it to have 1000's of simple products or is there a better approach using titles combined with product attributes?
If I go with 1000's simple products route, what are the common performance pitfuls I should be aware of to work around? For example in Opencart, I restricted it calculating the number of products in a category, heavily customised the search function and introduced custom page caching and optimised all the table indices to support large numbers of products being searched.
What is the best way to add new products to programmatically? Opencart I was working directly with the data tables, this was fast and didn't tie up the server too long when making large changes.
How do I manage logical inventory? With Multiple products representing one inventory item? "The Bulb", what is the best approach.
I am going to be needing to migrate customer data and orders - but I want to see if the inventory system is up to scratch first for what I need.
I am happy with taking on this work, doing the reading and legwork, but if people are able to point me in direction of I wish I read this first or understood this first from there experience of working with Magento.
So far my research I've found:
TABLES that are updated when creating a product
What are the main tables that updated when we creating new product in magento?
Very useful Table Entity-Relationship diagram for Magento:
Magento 2: Diagram of database tables, such as Orders, Products, etc. and their relationships
Many thanks!
magento2 module database migration extension-attributes
asked Jun 28 at 10:28
Gregory William BryantGregory William Bryant
11 bronze badge
TLDR: Migrating Opencart to Magento, currently have 300+sku's and 100k+ product pages. What is the best practice for storing complex product data and programmatically adding and maintaining it directly to the database? What tables need to be updated, in what order and how best should I structure the product data.
The Detail:
Hello everyone in Magento community.
I am new to Magento and I am hoping through this post, user can point me in the direction of the best reading resources to answer some of my broad questions. Also, any specifics on how to tackle the solution would be very much welcomed.
So to the business problem. I am currently running Version 1.5.5.1 of Opencart, with a store of probably around 150,000 products.
Simply put, I am happy with how the store is operating, but due to the version, I am forced with either migrating to later version of Opencart, moving to Magento or rewiring my old store to work with newer versions of PHP.
Here - I'm looking for advice on migrating to Magento and how best to approach it.
Currently, my store is uniquely set up, as the product database is maintained by the backend c# system I've written myself. This is because managing the volume of products I have is just not tenable in Opencart.
Of particular importance, is conceptually for every one product in my local system, it generates 100's if not 1000's of product variations that get loaded onto Opencart.
To explain further, let's take a simple analogy of Car headlamp bulb. My site would advertise as sell:
Headlamp Bulb Ford Focus St
Headlamp Bulb Ford Focus Hatchback (2011 - 2018)
Headlamp Bulb Ford Focus Hatchback (2005 - 2011)
Headlamp Bulb Ford Focus RS (2009 - 2010)
Headlamp Bulb Ford Focus Estate (2011 - 2018)
etc etc
So for each make, model, variation the bulb fits, there would be a logical product on my site with a unique URL. My site doesn't sell headlamp bulbs, but this is just for example purposes.
The single product on my C# backend has an array of all the appropriate models a part will fit, then generates all the data for a website by interacting directly with the Opencart database via SQL.
I am now looking at migrating this process to Magento. With this I have the following questions:
What is the best way to logically represent the products in Magento and still have the "Headlamp Bulb Ford Focus Hatchback (2005 - 2011)" breakdown in the product title. Is it to have 1000's of simple products or is there a better approach using titles combined with product attributes?
If I go with 1000's simple products route, what are the common performance pitfuls I should be aware of to work around? For example in Opencart, I restricted it calculating the number of products in a category, heavily customised the search function and introduced custom page caching and optimised all the table indices to support large numbers of products being searched.
What is the best way to add new products to programmatically? Opencart I was working directly with the data tables, this was fast and didn't tie up the server too long when making large changes.
How do I manage logical inventory? With Multiple products representing one inventory item? "The Bulb", what is the best approach.
I am going to be needing to migrate customer data and orders - but I want to see if the inventory system is up to scratch first for what I need.
I am happy with taking on this work, doing the reading and legwork, but if people are able to point me in direction of I wish I read this first or understood this first from there experience of working with Magento.
So far my research I've found:
TABLES that are updated when creating a product
What are the main tables that updated when we creating new product in magento?
Very useful Table Entity-Relationship diagram for Magento:
Magento 2: Diagram of database tables, such as Orders, Products, etc. and their relationships
Many thanks!
magento2 module database migration extension-attributes
magento2 module database migration extension-attributes
asked Jun 28 at 10:28
Gregory William BryantGregory William Bryant
11 bronze badge
asked Jun 28 at 10:28
Gregory William BryantGregory William Bryant
11 bronze badge
asked Jun 28 at 10:28
Gregory William BryantGregory William Bryant
11 bronze badge
asked Jun 28 at 10:28
Gregory William BryantGregory William Bryant
11 bronze badge
asked Jun 28 at 10:28
Gregory William BryantGregory William Bryant
11 bronze badge
11 bronze badge
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f280062%2fhow-do-i-add-product-data-and-directly-to-the-database-which-tables-need-to-be%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f280062%2fhow-do-i-add-product-data-and-directly-to-the-database-which-tables-need-to-be%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
