I am adding the amount of 2xx of fields to a content type at /admin/content/node-type/product/fields
, is there any alternative way such as SQL statement to add these fields?
Thanks
Do you mean you're adding over 200 fields to a content type?! Yikes!
If so, I'd strongly recommend you look into:
The issue comes down to practicality and future development... Imagine the size of your edit forms! Huge forms can actually cause problems for people's computers due to memory limitations. Imagine trying to debug or style such forms...
By breaking up the content type into groupings of fields, and collapsing discrete fields into text areas you can better normalise the data and, for a little extra work up front, save yourself a lot of pain later.
Drupal fields have entries in several tables and need many settings created, so I'd avoid using SQL to do it as it'd probably be much more work than just manually adding them.