@kushagrajain,
Sorry for the late reply, I've been a little swamped here and I'm getting caught up on forum questions. At this time, we do not have an OOB solution for imports as you have described, although we are currently working through it.
We've given some thought already to your question, and I think what makes the most sense is to import them in separate steps. So first, you would import a ZIP file containing all of your assets. You can see what goes on in the AdminAssetUploadController for some guidance on how you might do this. So say you had these images in your zip file:
img1.png
img2.png
img3.png
That would make the following URLs available that you could reference in your URL entries to Media:
/cmsstatic/img1.png
/cmsstatic/img2.png
/cmsstatic/img3.png
After those are uploaded, you could then go to Products and issue an upload there. For dependent tables as you asked about (default Sku media is one of those) then you would have to parse out whatever is in the column and then persist that to the database. You might support some value syntax like 'primary:/cmsstatic/img1.png|alt1:/cmsstatic/img2.png'.
We know it's a pain point that we don't have a good way to do this OOB. We will start thinking about exporting relatively soon after import.
This forum is in readonly mode and serves as an archive of old information. All posting, registration and commenting abilities have been turned off. To get help, the Broadleaf team reguarly monitors the broadleaf-commerce tag on Stack Overflow so please ask your questions there.